Jsut a quick question.. How can we remove the SP from predefined Snapshot Replication? Ashish
Thanks Satya, I dropped the login with this and now the problem resolved. IF EXISTS (SELECT * FROM sys.server_principals WHERE name = N'time') DROP...
I am getting the error of User already exists..
Its not showing in the list of orphaned user as welll..
Hi Friends, I have a problem in SQL Server 2005. I created a login(SQL Authentication) and then delete it from Mangement Studion. Then again...
Hi Friends, Is there any inbuild utility which can facilitate to access MSMQ directly in SQL Server 2000? Regards Ashish Kuriyal
Hi Friends, Though the request is out of scope, but I am sure someone would be having the answer. Is there someone whi is having any document/idea...
Hi, Please help me to fill the hardware requirement for servers which need to be used for SQL Server 2000 and 2005.These server will be used in Dev...
Is it possible to stop those steps which are not required and showing as executing status in different logs of same version of DTS... Ashish
OK great. Thanks a lot. Is there no entry similar to this in MSDB databases's tables
I mean 0
Are u sure about that. Because if I check the Log then there are lot of entries of the Last version in the single DTS which shows status as 4. So are...
Hi, Need help in troubleshooting the DTS. The last night I execute the package from DTS--Local Packages. Generally it takes around 12 hrs. Now in...
No, its related to full text indexing on int datatype of SQL Server 2005 Database.
Is there no alternate to accomplish this task?
Thanks for knowledge but I already know that full text indexing can be used only on these datatypes. But what if the datatype is int and want to use...
Hi All, How can we use the int type column in full text indexing? Regards Ashish Kuriyal
Its really good news Satya. Please update us once its completed with the proper URL and thanks for contributions/solutions which you provided in the...
Thanks a lot. I guess we created a wonderful document which will help others also. If anyone have further suggestion then please keep updating this...
Thanks for such a perfect and prompt reply. So is there any option using which I can reindex the all indexes available in a perticular databse.
Separate names with a comma.
