Viewing 15 posts - 136 through 150 (of 1,065 total)
Patrick_Fiedler (4/27/2011)
2. You can simply update the inserted table because the data in the inserted table would be added to the Employ table after execution of this trigger.
Well that's something...
April 27, 2011 at 3:35 am
That probably means your trace is still running.
I don't have access to SQL Server at the moment to give definitive instructions, but you need to find out the id of...
April 22, 2011 at 3:48 am
Create your trace using the profiler GUI, then Export your trace definition to a file so you have all the SQL commands to create the trace.
Modify the script to set...
April 21, 2011 at 8:50 am
It looks as though you stored procedure is being invoked by something that has already started a transaction, (i.e. the transaction count is already 1 when the stored procedure starts)...
April 19, 2011 at 6:48 am
WayneS (4/8/2011)
If you decide you really need it as varchar, then make that a calculated column.
Ignore my suggestion, Wayne's is far more sensible.
April 8, 2011 at 7:48 am
That looks like an error from your application, not SQL Server, so will need to delve into the application to see what it means.
April 8, 2011 at 6:25 am
Does the date you will be comparing (e.g. @SomeDate in your example) contain a time element?
If not, then you won't have a problem, as both the lookup table and date...
April 8, 2011 at 6:24 am
I've no idea why one script runs, and the other doesn't. As you say, the only difference is a column that has nothing to do with the RIGHT function.
Are...
April 5, 2011 at 8:13 am
What is the default database for the job step running the restore?
April 5, 2011 at 3:12 am
Without seeing the input data, this is just a guess...
Your RIGHT statement is looking for "for_" (_rof reversed) in the import file name, and I'd bet that one of the...
April 5, 2011 at 1:36 am
Check that the last line of the file has the CR/LF terminator (or whatever your line terminator is).
April 5, 2011 at 1:03 am
SQLkiwi (4/1/2011)
Hi everyone. Just to confirm it officially: I am now a SQL Server MVP
I'll echo all the other sentiments... Congrats Paul, well deserved IMHO.
April 4, 2011 at 1:37 am
phbarn (4/1/2011)
April 1, 2011 at 9:05 am
OK, I get it now.
Why not just backup the live database and restore to development as and when required?
April 1, 2011 at 8:05 am
ALZDBA (4/1/2011)
please keep in mind this is an old thread ( Posted 1/21/2008 )
Doh!!:blush:
April 1, 2011 at 8:01 am
Viewing 15 posts - 136 through 150 (of 1,065 total)