Viewing 15 posts - 46 through 60 (of 333 total)
Can you post with SQL version (2000 or 2005)
More info at..
http://blogs.msdn.com/blakhani/archive/2007/10/16/sql-server-2005-blocked-process-report.aspx
February 12, 2008 at 11:17 pm
above are applicable only for SQL 2005.
If you don;t have traces running, you have no way to find out in SQL 2K
January 25, 2008 at 11:02 pm
Can you run select @@servername and verify the name is correct on both servers (same as physical name of machine)
I have a feeling that they are not the same.
January 2, 2008 at 3:07 am
taking full backup in full recovery model does NOT truncate transaction log. You have to take regular t-log backups.
Refer Below articles.
317375 INF: Transaction Log Grows Unexpectedly or Becomes Full on...
January 2, 2008 at 1:02 am
Here is the explaination:
You have created table as below.
SET ANSI_NULLS OFF
GO
CREATE TABLE [ZZZ_employee] (
[emp_id] int NOT NULL ,
[fname] [varchar] (20) NULL ,
)
GO
Lets put same data
insert into [ZZZ_employee] values...
January 2, 2008 at 12:58 am
1. what is the version on linked server? both are on same build(SQL 2005 SP2?)
2. Are you able to reproduce it? Do you have small sample?
3. Are you using Truncate...
December 27, 2007 at 12:27 pm
944517FIX: Error message when you create a WMI event alert by using the sp_add_alert stored procedure in SQL Server 2005: "The @wmi_query could not be executed in the @wmi_namespace provided"
November 15, 2007 at 10:33 pm
I am not sure what you are trying to achieve.
But you can use WAITFOR DELAY command and put in While Loop.
my 2 cents.
November 15, 2007 at 9:57 pm
Principle server is still down? You can do a force failover
November 15, 2007 at 4:57 am
what exactly you have put into the job?
November 15, 2007 at 4:52 am
What is the account by which you have logged in?
Most likely you account is not a member of sysadmin role, then the SQL Server 2005 will use the proxy account...
November 15, 2007 at 4:45 am
Its always good to take all databases backup before doing any upgrade. You never know if you want to go back to previous version.
November 15, 2007 at 4:39 am
Thats the issue with inline function. SQL will not be able to make estimates and assume 1 row which can make plan bad. How many rows are there in person...
July 10, 2007 at 3:09 am
SID is for a login. If you create new login to server it would be generated. In SQL 2005 Server, you have to create the login and restored backup taken...
July 10, 2007 at 12:43 am
Viewing 15 posts - 46 through 60 (of 333 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy