So is there any way to get away from this bad smell? :)
Hi Martin, Thanks for the response. This is what we are trying to do.This is not the whole stored procedure but it should give you good idea. Below...
Hi there, In one of my query,when i am test and providing the hard coded values in the where close for the filter, it finishes the query in less than...
Thanks for the information. I will certainly look into this. Just for my knowledge, does replication recreates the objects everytime the schema...
Hi Satya, Thanks for the response (as always). Because two database are on different servers and owned by two different teams. So whenever the Team A...
Hi there, We have replication in place for certain objects in 2 database which are backend of different application. And I am writing a script to...
Thanks, this was helpful.
How can i create a field in table which can not be null if the Field2 in the same table is not Null. Thanks in advance!
Hi there, My machine got corrupted with virus and i ended up deleting the windows account from the machine. Now when i try to connect to sql server...
Hi Satya, I am the only admin and but we have several projects which are outsourced. Lately the project went live and we are working on the...
Hi there, Is there any way to find out if the profiler is already ON for a specific server? Thanks!
Hi there, Is there any harm if i need to shrinkl the Model database? Is there any thing different I need to do or the same process to shrink as user...
Hi there, We are planning to install SP3 for our SQL Server 2005. The major application will be effected by this is SharePoint 2007. Does anyone have...
Thanks guys, that was really helpful.
Hi there, In our sql cluster set up we have all the services on one node other than SQLCluster DTC and SqlQueue services. Now we need to restart the...
Hi there, We are in process of migrating our servers to a new location. For disaster recovery plan, I am working on the script all the Logins (with...
Hi there, We are planning to apply Service Pack 2 for SQL Server 2005 servers. We have Active - Passive clustering. Is there anything we need to be...
Thanks guys, i appreciate your suggestions.
Hi there, Today, I had to restore a database. As it was a production database, i got the database into single user mode by selecting that from...
Hi there, I have reports which are working from the development work station, after deployment when i try to run them from report server, they work...
Separate names with a comma.
