Viewing 15 posts - 886 through 900 (of 1,161 total)
Please check the following.
Is the password for pubuser correct?
Does the pubuser has requisite permissions on the database?
Is the default database for pubuser is set correctly?
August 3, 2010 at 10:31 pm
Looks like some of the components of SQL 2005 are already installed. Un-installing them may help.
August 3, 2010 at 10:25 pm
No problem. Nice to know that it was useful for you !
August 3, 2010 at 9:14 pm
Restarting the SQL Services will resolve this issue temporarily. However in the long run you may want to check the memory requirements or consider increasing the mem_to_reserve value.
August 3, 2010 at 1:39 pm
The memory allocation depends on the load that SQL Server is going to handle. This article[/url] explains it better.
August 3, 2010 at 1:35 pm
You may find these articles useful.
http://www.sql-server-tool.com/compare-two-tables.htm
http://weblogs.sqlteam.com/jeffs/archive/2007/05/02/60194.aspx
August 3, 2010 at 1:29 pm
You created one more database? I did not get the question
August 3, 2010 at 1:24 pm
Check if DSQUERY GROUP returns the same results as xp_logininfo?
August 3, 2010 at 1:17 pm
That is a good approach. You may use this query to check for the fragmentation of the tables.
select object_name ( object_id ) as [Table Name] , index_id , avg_fragmentation_in_percent from...
August 3, 2010 at 10:00 am
The answer was available in the Hyperlink I provided in the previous post. You may query the default trace as per your requirement. However, I have given the below example.
select...
August 3, 2010 at 7:34 am
Both the links that I provided have "How to" do it information on Importing a custom DLL. If they are not useful then I might have misread the requirement.
August 3, 2010 at 5:35 am
You may want to go through the Default Trace of SQL 2005. This article[/url] explains on how to do it.
August 3, 2010 at 5:29 am
You may safely move that folder to some other location. In SQL Server 2000, there was a dependency on this folder, since it used to store the Outlook configuration used...
August 3, 2010 at 4:31 am
Is there any information in the Application/System Event Log when this exception occurs?
August 3, 2010 at 4:25 am
What does the four part query (ServerName.DatabaseName.OwnerName.ObjectName) return?
Does it throw any error?
August 3, 2010 at 4:19 am
Viewing 15 posts - 886 through 900 (of 1,161 total)