Team, Thanks for all your suggesstions. It is solved now. We used fast copy setting. THis setting locks the target table and does not even allow any...
Insert into TableC values select X.column3, B.column5, B.column6, X.column4, Sum(x.column8) Sum(x.column9) . . . . Sum(B.column10) FROM [TableX] X...
If I upgrade my reporting server from SQL Server 2005 to SQL Server 2008, will there be any change in the folder structures created by SQL Server...
Please let me know if we need to do any RDL file changes for reports, if my underlying data source chages from SQL Server 2005 to 2008
Team, I have to upgrade SQL Server 2005 EE 64bit Active/Active cluster on Windows 2003 to SQL Server 2008 EE 64bit Is it recommended to upgrade the...
Second incident, As System DBA (he calls so) , while fixing a tape device, he wrongly tried to plug-in the power to the back of the tape. Though it...
Nope he is not bcos I changed my job form there [:)]
Me along with another friend used to maintain the Production servers and databases of leading MNC Bank. Since he is System DBA and not SQL Server...
Team, I need to keep all the AD details (groups,users,..etc) in my database. One way is to create a linked server to ADS service and get the info Is...
Team, Will SQL Server 2005 will support to connect to SQL Server 2008 database High level guidance will be very much appreciated Regards Prabhu S
Thanks Mohammed. The only thing I am worried is the volume is huge 300 million. When we do the data type change from int to bigint, sql server...
Friends, Our SQL Server database hosts around 1.1 billion data occupying 450 GB of memory. Runs in a single server without partition. Every month...
Yes. The client insists on Clustering setup The main thing I would like to know is is it possible to set up Replication/Logshipping between the...
Is the possible to set up clustering as described below Set up SQL Server 2005 Cluster Install two instances of SQL Server in this cluster in...
We are trying to install the SQL Server 2005 Enterprise 32Bit Edition in a clustered SQL Server 2000 environment and keep receiveing the following...
YES YES YES Its works fine. The faults which I did... 1. I have restored the database from principal to mirror with RECOVERY Resolution:...
I am getting the error 1416 database 'xyz' is not configured for database mirroring I don't see much info on how to solve this one. anyone faced...
Thanks for your replies... This is the first time i am trying to test the mirroring feature. I will go thro' the sites you have mentioned and update...
I am getting the following error when I run the command ALTER DATABASE mirroring SET PARTNER = 'TCP://ltihp00460.cts.com:5022' Msg 1418,...
Thanks for that . My scenario is different.My script is like this ****************************************************************************...
Separate names with a comma.
