No Satya. Actually this our node. We have uninstalled all the instances and try to install SQL Server 2008 and installation failed with errors and...
No.. We have not changed any SA account and we are installing new SQL Server 2008 Installation. Regards, Ganesan....
Hello All, We are installing SQL Server 2008 enterprise edition in our PC. But databaseengine, repoting services and agent services shows failed at...
Hi, Please give me the steps to follow to migrate the SQL Server 2000 Database Server to SQL Server 2005. Regards Ganesan
Suppose we have two servers with merge replication. Same time publisher also updating same record (same table). Subscriber also updating same record...
Yes Luis Martin. you are right. Earlier I'm doing Development DBA. Now I started to look Production DBA also. so that I'm updating myself. Ganesan...
Thanks chetan. One more thing Database failed at 5:30. But I have upto 5 PM transaction log backup. Can I restore the database upto 5:30? Ganesan...
What I'm wondering is we can't just play with system tables. That's why I'm fearing .... Ganesan B. Well defined problem is half way solved.
You use use exists instead of in Ganesan B. Well defined problem is half way solved.
We are moving old SQL Server to new server. Everything is same. I have moved database also. But I have 1000 logins in old server. How can I move...
Hi, I 'm new to DBA. Based on the following scenario pls let me know how can we store. I have Full backup of Sun 10 AM I have differential backup...
Please any one tell me about usage of collation in sql server 2000. Always I setup with default only. Ganesan B. Well defined problem is half way...
My database backup is daily differential sunday Full backup. we are replacing same file. From Disk sys admin person will put...
If you are using OSQL then how will be your result set. I think that will be in some file. then you need to do play around that file to get all...
quote:Originally posted by sql_machine I notice a lot that at the end of stored procedures some people place error trapping like: SET @ErVar =...
quote:Originally posted by guanjm Which one will be a better choice? ------------------------------- 2 and 3 Please give some information......
Instead of using IN and NOT IN better to use EXISTS AND NOT EXISTS. EXISTS and NON EXISTS give us better performance than IN and NOT IN Ganesan B....
quote:Originally posted by Madhivanan quote:Originally posted by balaganesh2k I wonder why nobody yet...
I wonder why nobody yet mentioned:http://www.sommarskog.se/dynamic_sql.html -- Frank Kalis Microsoft SQL Server MVP http://www.insidesql.de Heute...
You can use the table variables instead of using cursors. we can stop usage of cursors with while loop. Ganesan B. Well defined problem is half...
Separate names with a comma.
