This is the scenario..... In the server we had we had sql server 2000 before but we upgarded it to sql server 2005....the stored procedures that were...
We have Sql server 2005 and working on SSRS.For creating a report a processiing server is used and for lookinmg at it a remote report server is...
The following query when executed will involve in a bookmark look up ,how to avoid bookmark look up for this query SELECT T1.CONFLICT_ID, CONVERT...
Ok. Thank you so much for your help
Thanks for your reply. But i need to change it for all 1400 logins.by using sp_defaultdb i can change 1 login at a time. I want to do it at a time.
hi I have some 1400 logins. I have to change default database for all this logins. Can i update syslogins table? will there be any problem if i do...
Hi I killed a spid 2 days back. Still i can see it in current activity console. In the command it shows " killed ollback". Is it still in rollback...
Thank you very much ranjit.
one of our servers crashed. we had backups of all the databases. so we reinstalled sql 2000 . then i restored master database. Then I tried to start...
Hi Everyone, I have small question in regards to taking a backup.I have a database <DB1> for which i need to take the backup.But i want the .bak file...
I am new to sql profiler.I started monitoring one of our application perfomrance using sql profiler I see that duration of execution of one stored...
Hi Everyone, I have a stored procedure that executes a couple of SSIS packages which loads data in to the table which uses XP_CMDSHELL. The login is...
I am implementing Transactional replication in 2005.Do i need to turn on or off "NOT FOR REPLICATION" option for identity columns? Thanks in advance...
I need to create an identity column in a table which i already present ....how am i supposed to create the identity column ....
Thanks a lot as I have changed the recovery mode to simple ....But I have another question now....There is no job that relates to the t-log back...
Thanks a lot as I have changed the recovery mode to simple ....But i ahve anither question now....There is no job that relates to the t-log back...
Hi All, The transactional log for a particular database in the server is growing very fast and everytime its creating a huge problem when we try to...
I restared sql 2005 machine. I am unable to access Management studio.I can open profile,business intelligence studio.But i cant open management...
Version is Enterprise edition 64 bit 9.00.3042.00
I have a sql server 2005 machine. .When i am accessing replication folder it says that"Replication component is not installed on this sever.Try to...
Separate names with a comma.
