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...
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...
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 ....
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...
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...
I have a small question in the process of replication we set up publisher,distributor and the subscriber.As a usual practice we do set up the...
Hi all, I have a problem while i create a proxy account.The situation is like this...There is a user who has an login in to the server.He has a...
Hi everyone .... I am having a problem with a login who is not able to execute the stored procedure which uses xp_cmdshell. For the user called...
Hi Everyone..... There are 3 servers ServerA, ServerB and ServerC. I need to replicate the data from Server A to Server C.But because of some...
Separate names with a comma.
