Viewing 15 posts - 43,846 through 43,860 (of 49,552 total)
Please post SQL 2000 related questions in the SQL 2000 forums in the future. If you post in the 2005 forums, people are going to assume you are using 2005...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 13, 2008 at 1:28 am
So, easily find out the procedure name and inner level too.
do you have any command then just tell me.
No easy way I know of on SQL 2000 or 2008. 2008...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 13, 2008 at 1:21 am
Matt Miller (10/11/2008)
All right - I will bite. What IS it going to be?
When you find out, please let me know.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 13, 2008 at 1:13 am
Try changing the foreign key to ON DELETE SET NULL. You should then be able to delete via the trigger. The reason you can't now is because the trigger fires...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 13, 2008 at 12:48 am
Duplicate post. Replies to the following thread please:
http://www.sqlservercentral.com/Forums/Topic584368-5-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 13, 2008 at 12:42 am
Please don't post multiple threads with the same topic. It just wastes people's timeas they answer posts already answered. It also fragments replies and makes things harder to find
No replies...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 13, 2008 at 12:40 am
Try dropping all three procs, recreate the inner one and then recreate the two outer ones.
If you create the dependant object before the object that it depends on (allowed in...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 13, 2008 at 12:37 am
Have a look at this blog post, see if it applies.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 12, 2008 at 2:29 pm
Peso (10/12/2008)
I was under the impression that temp tables always are written to disk because they are affected by transaction operations, which table variables are not.
The changes will be logged...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 12, 2008 at 2:03 pm
The first thing that I will recommend is that you go and explain to your boss what has happened. Hiding mistakes makes them worse, and there's a good chance that...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 12, 2008 at 1:20 pm
In that case, the proc should look like this
CREATE PROCEDURE dbo.sp_Chop_Status
@Chop_ID nVarChar(6) = NULL,
...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 12, 2008 at 12:39 pm
Backup log with truncate only will discard inactive transaction log entries from the tran log. This frees up space within the log file that can then be released to the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 12, 2008 at 12:30 pm
Ok...
Are you trying to return a resultset (from the select statement) or just a output variable?
The error is correct. In terms of the SET statement, the column CalculatedStatus does not...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 12, 2008 at 12:24 pm
Duplicate post.
Replies to the following thread please:
http://www.sqlservercentral.com/Forums/Topic584586-1292-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 12, 2008 at 12:19 pm
"Data Source=(local)" resolves to the default instance on the local machine. Express always installs as a named instance with the instance name "SQLEXPRESS"
Try "Data Source = < Server name...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 12, 2008 at 12:15 pm
Viewing 15 posts - 43,846 through 43,860 (of 49,552 total)