I wanted to know if there's a limit on how many targets I can manage in Multi Server Administration.In addition, are there any known limits regarding managing SQL instances with different versions (SQL 2005,2008,2008R2 and 2012).
View 4 RepliesMy product is growing rapidly and currently I have a db for each client with identical schema. Of course maintenance is pretty hard. I was thinking of using a shared db but having a schema for each client (sql 2005) - I have almost 100 tables in the schema which means with just 10 clients the db would pass 1000 tables. My gut is telling me this ain't going to fly!any ideas? and if it does work ... any thoughts on updating the internal schemas for each client?thanks-c
View 2 Replies View Relatedi have a column with mulitple ids stored with commas . i want to pass ids and get data along with name from the table..how to get multiselect value in a variable in sql server function
View 4 Replies View RelatedI am new to programming trying hard to learn. I made a code for Views in mssql for the 2 tables below:I am wondering if I could make it 3, 4 or more tables at the same time. How can incorporate in the following codes I made.
Create View vwEmployeeInfoByGender
as
Select FirstName, MiddleName, FamilyName, Gender, BirthDate,
MaritalStatus
from tblEmployeeInfo
join tblGender
on tblEmployeeInfo.GenderID
= tblGender.GenderID
I am trying to place a database offline.
When I right in Microsoft SQL Server Management Studio on the database > Take Offline
Set offline failed for Database 'OperationsManagerAC'.
Transaction (Process ID 56) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. ALTER DATABASE statement failed. (Microsoft SQL Server, Error: 1205)
So I am trying with some queries to pass the database from Single user to multi user but it fails
USE [master]
GO
ALTER DATABASE OperationsManagerAC SET MULTI_USER GO
Msg 1205, Level 13, State 68, Line 1</p><p>Transaction (Process ID 52) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
I tried also
alter DATABASE OperationsManagerAC SET OFFLINE WITH ROLLBACK IMMEDIATE
IT FAILS AS WELL... with the same error... how to run the SQL Statements without using
How to proceed next?
Where can I find info on how much data SQL Server can handle? What is too big of a table in terms of records? When (in terms of table/db size)does processing from a web site using querys and joins begin to bog down?
Thanks!
Im curious about how much data SQL Server 2000 can handle. Where does SQL Server stand today comparing to Oracle? It would be interesting to hear views and experiences from people here on swynk on SQL Server 2000. How big are the biggest tables, how many rows and speed etc. When is it time to consider using Oracle, if ever, instead of SQL Server 2000?
Regards,
S
Hi folks. I'm trying to clear up some licensing confusion I"ve come across. First, if I use MIRROR on SS SE I am limited to a single REDO thread and Sycn mode. I see that on the Web. Will the singel REDO thread hurt the ability for the Secondary to keep up? Any one done any tests?
My confusion comes from a document that came across my desk a long time ago that showed that if you use MIRROR on SQL Server SE you are limited to 4 processors for the entire cluster. So if you wanted a balanced failover you would have to have two 2-ways in essence. Is this true? Is it not longer true? I can't seem to find any mention of this....did someone give me bad advice? Help! Thanks.
Is it possible to write an ASP.NET app that can do certain SQL Server 2000 administration tasks, specifically add sql server users, and change sql server user passwords? Would it just be a matter of running the appropriate system stored procedures (sp_password, etc.), or does .NET provide any hooks into SQL Server for something like this? Thanks!
View 5 Replies View RelatedHello all.
For my first foray into this forum I have a tricky one....
We have a table in our database called tblJob with two columns:
id IDENTITITY(1,1)
jobNbr VARCHAR (5) (This would be, for example '12323')
When a new job is created (i.e. job Number 12323), the client wants a trigger on this table that creates a new table called tblJobData12323.
Does anyone know how I can accomplish this?
Thank you in advance.
PJ
PJ
Is there a limit to how much text you can concatenate (other than datatype limits, of course)? For example, if you write:SELECT 'This is some text from: ' + Convert(char(15), SomeFieldName01)+ 'some more text' + Convert(char(25), SomeFieldName02) + 'yet moretext.' As BigNoteFROM TableIs there a limit on how much you can concatenate into that big notefield, meaning is there a limit other than the size of the data type?
View 4 Replies View RelatedWhat are the limits of SQL Server 2005 Express. I have 500,000 records and 60 users. Is this acceptable?
View 1 Replies View RelatedI'm new in the DBA position recently aquired, and I'm having a few issues with MSSQL configuration and administration.
1. I have created a two maintenance plans, one for system databases and another one for user databases, this plans include things such as, Integrity Checks, Optimizations and DB Backups, however the Integrity Checks fail with the error that the DB's must be in single user mode, how can I go about to make this and what are the implications of doing so?
2. There's been a few reports of MSSQL server compromises through UDP port 1433, so I closed it at firewall level, only TCP 1433 is going through, do I really need UDP 1433?
Thank you very much.
Sorry for starting a new thread on this subject but my situation is a bit different.
I want to connect to a remote SQL-server in a DIFFERENT domain, using Enterprise Manager. Whatever I try, I allways get an "SQLserver not found"-error.
The ASP's on the server that make use of the SQL server are functioning without any problems, so I guess the SQL-server itself is OK.
I tried:
servername = URL remote server
setting up a linked server
setting up a remote server
I'm a webdesigner and a newbe to SQLserver7. Please keep in mind I could be overseeing something that very obvious for you.
So what could be the problem. Any tips? Thanks!
Is there a way to remotely control SQL server 7.0 from NT workstation
and win98?
Thanks
williams
Hi
i Would like to know is there any tool which would allows me to manage database over the web i.e from a brower
if any tool is there can any one let me know from where i can get it
thanks
Prasad
(Post removed)
View 3 Replies View RelatedI'm searching for some alternate administration tool (permisions, rights,etc.) on sql server, something not so complicated as default. Does anyonehave some info about that? ThanksPete
View 1 Replies View RelatedI've been developing a vb app with sql server 2005 and had planned to use express as the client server so the db could be distributed with the app. After importing 21 csv text files, I realized that I have way too much data. My understanding is that sqlexpress can only work with max 4gb database.
The 21 csv files (total 925mb) brought the db size up to 1.5gb and I still have at least 250 more files to go. Obviously, I need a different approach. What are the size limitations of the non express version of sql server 2005? Any suggestions on the best approach for this type of situation?
Hi All, I will shortly (hopefully) begin devleoping an ASP.Net web application to let users manage a remote sql server 2005 database (kind of like the php myAdmin tool for MySQL databases). Were not talking a server managament tool for DBAs, more an end user tool for managing personal databases (it seems that web hosting companies provide tools for MySQL, but if you use SQL Server, you're stuck unless you have management tools on your PC - and what about mac users?).Given that premise, what features should i attempt to include? Creating and modifying tables structures and data is an obvious inclusion, but what else? I also haven't yet decided whether to go about this using scripts or using SMO. I've read that SMO is backwards compatible across versions of SQL Server...how true is this? are there issues or is it seamless? Please post any comments or thoughts you have, and thanks for taking the time.
View 4 Replies View RelatedHello,
I need an Administration tool for SQL SERVER 6.5 compatible with WINDOWS 2000.
When I try to search one with GOOGLE, I find none ...
If anyone can provide me with any solution, he (or she) will make me the most happy of the DBAs today ...
Thanks in advance
Al'
Hi All,
Can anybody list out good books for Sql server 2000 Database Administration for a beginer level to the expert.
And also the good resource /sites/forums for learning ,administering and for certification. Which is the best way to busy and where???
I am an oracle //informix DBA
Thx in Advance
Kpai
I am new to VWD, and web development. I installed VWD and SQL Server Express local.
I'm learning how to use the VWD with some of the walkthrough samples. It was going great until I got to the walkthrough where it show "how to use configure user and role with Web Site Admin Tool". I followed the walkthrough steps by step. I clicked the Security Tab and I got the following error:
"There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store. The following message may help in diagnosing the problem: Unable to connect to SQL Server database. "
I read some article. According to the articles, SQL Server Express will automatically create the asp database for the first time. but my SSE did not create the database.
What did you do wrong? Please help. Thank you
TCF
I have multiple SQL 2008 severs with databases. Also, 1 mirroring server in place.
Since my database count is increasing can i have only 1 mirroring server. Is there any limit of db at mirroring server. I would have approx. 150 databases.
I have installed Sql Server 2000 Personal Edition (Version: 8.00.2039 SP4 Personal Edition), it runs over Windows XP.
Has Sql Server 2000 Personal Edition any user limits?
Thanks for reply
Ariel
Hi,
I am an Oracle DBA with over 7 yrs of experience.I am new to sql server 2000 and am given the responsibility of sql server 2000 production databases in a few weeks.I already have the sql server 2000 DBA survival guide.
I would like to know if there are any good books out there for
a)backup and recovery
b)General DBA tasks
c)Performance tuning.
Thanks,
Copernicus
I am running SQL Server 2005 Standard Edition with SP2 on Windows XP professional. When I check the microsoft documentation, it says that it is not possible to setup multiserver administration in standard edition. Have anyone tried this in Standard edition.
Rajakanna
I installed SQL Server 2005 Express Edition, I can login to it just fine using SQL Server Management Studio Express. I ran the aspnet_regsql and it created the aspnetdb database. But when I try to test the AspNetMembershipProvider or go to the Security tab in the ASP.NET Web Site Administration Tool it does not work. I have tried messing with the connectionString of the LocalSqlServer in the machine.config, but to no avail. My SQL Server is installed on the Default Instance. Can someone help me get ASP.NET Web Site Administrator to work with my SQL Server 2005 Express Edition?
View 1 Replies View RelatedI'm not quite sure where to post this question, so I'll try here. We've been struggling getting SQL2005 reporting services integrated with Share Point Services 3.0 for several days now.
We've installed SQL Reporting Services with SP2 and run the SharePoint Reporting Services add-in. We've been able to go through the SQL Reporting Services Configuration and now were at the last step in the SharePoint Application Management Reporting Services configuration.
The first two steps of Manage Integration Settings and Grant Database Access was sucessful. The final step of "Set Server Defaults" gives us a 404 error message. There is nothing in the Event Log to suggest that there was a problem, and the SQL2005 Server is in SharePoint Integration mode. I've searched but can't find a solution. Can anyone steer me in the right direction please?
I am new to Reporting Services and hope that what I am looking to do is within capabilities :-)
I have many identical schema databases residing on a number of data servers. These support individual clients accessing them via a web interface. What I need to be able to do is run reports across all of the databases. So the layout is:
Dataserver A
Database A1
Database A2
Database A3
Dataserver B
Database B1
Database B2
Dataserver C
Database C1
Database C2
Database C3
I would like to run a report that pulls table data from A1, A2, A3, B1, B2, C1, C2, C3
Now the actual number of servers is 7 and the number of databases is close to 1000. All servers are running SQL2005.
Is this something that Reporting Services is able to handle or do I need to look at some other solution?
Thanks,
Michael
Disaster Recovery Options based on the following criteria.
--Currently running SQL 2012 standard edition
--We have 18000 databases (same schema across databases)- majority of databases are less than 2gb-- across 64 instances approximately
--Recovery needs to happen within 1 hour (Not sure that this is realistic
-- We are building a new data center and building dr from the ground up.
What I have looked into is:
1. Transactional Replication: Too Much Data Not viable
2. AlwaysOn Availability Groups (Need enterprise) Again too many databases and would have to upgrade all instances
3. Log Shipping is a viable option and the only one I can come up with that would work right now. Might be a management nightmare but with this many databases probably all options with be a nightmare.
More often than not, I typically don't touch DTC on clusters anymore; however on a project where the vendor states that it's required. So a couple things here.
1) Do you really need DTC per instance or one for all?
2) Should DTC be in its own resource group or within the instance's group?
2a) If in it's own resource group, how do you tie an instance to an outside resource group? tmMappingSet right?
the stored procedure don't delete all the records
need help
Code Snippet
DECLARE @empid varchar(500)
set @empid ='55329429,58830803,309128726,55696314'
DELETE FROM [Table_1]
WHERE charindex(','+CONVERT(varchar,[empid])+',',','+@empid+',') > 0
UPDATE [empList]
SET StartDate = CONVERT(DATETIME, '1900-01-01 00:00:00', 102), val_ok = 0
WHERE charindex(','+CONVERT(varchar,[empid])+',',','+@empid+',') > 0
UPDATE [empList]
SET StartDate = CONVERT(DATETIME, '1900-01-01 00:00:00', 102), val_ok = 0
WHERE charindex(','+CONVERT(varchar,[empid])+',',','+@empid+',') > 0
TNX