Viewing 15 posts - 2,086 through 2,100 (of 2,356 total)
sp_addserver @server = 'Servername', @local = 'local'.
This re-sets the value of @@SERVERNAME
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
March 20, 2015 at 12:07 pm
cbosman0 (3/19/2015)
Michael L John (3/19/2015)
There is likely some data in this field that cannot be converted to a date.See what this returns
SELECT Field
FROM Table
WHERE ISDATE(Field) <> 1
Hi,
With above it...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
March 19, 2015 at 7:30 am
Your answer is in the message:
"the server network address cannot be reached or does not exist. check the network address and that the ports for the local and remote endpoints...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
March 19, 2015 at 7:04 am
There is likely some data in this field that cannot be converted to a date.
See what this returns
SELECT Field
FROM Table
WHERE ISDATE(Field) <> 1
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
March 19, 2015 at 7:00 am
Just guessing, but...
What is tempdb sized at?
Do you have instant file initialization enabled? To do this, the SQL Server service account needs to be granted "perform volume maintanance tasks"...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
March 16, 2015 at 7:11 am
How about these articles:
http://www.sqlservercentral.com/articles/Miscellaneous/allabouttransactionspart1/1583/
http://www.sqlservercentral.com/articles/SQL+Puzzles/allabouttransactionspart2/1586/
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
March 12, 2015 at 4:53 am
below86 (3/11/2015)
CELKO (3/11/2015)
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
March 11, 2015 at 1:42 pm
At the risk of sounding harsh, if you cannot understand a complex query that has more than X number of joins, then is that something you really should be doing?...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
March 9, 2015 at 8:17 am
Did the installation of the service pack fail? If so, I agree with Ed. Download a new set of installation media.
If the SP installation succeeded, and there are missing...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
March 6, 2015 at 9:32 am
Yes. This will work.
The simplest solution is usually the best solution.
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
March 6, 2015 at 9:27 am
Simplify this.
In the update trigger, delete the rows in the slave tables that match the deleted table, and insert the rows in the slave tables from the inserted trigger.
You...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
March 6, 2015 at 9:18 am
renato.guiglia (3/6/2015)
First of all, thank you very much for your time! 😉
Send Beer.
I recommend a "holding" table. The triggers insert the old and new values into this table, a separate...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
March 6, 2015 at 8:44 am
yes, one trigger for each operation. It is better to have only one trigger to manage all?
In this case, three triggers work best.
This is the problem: if i UPDATE a...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
March 6, 2015 at 4:42 am
I tried your DELETE Script, but it didn't work: i think that you would use DELETED table.
My mistake!
Your UPDATE script is correct ONLY if you update description field.
If you run...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
March 6, 2015 at 3:23 am
Why do you need two tables with the same data? From a design perspective, this probably makes no sense.
If you are going to create code that inserts, updates, or...
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
March 5, 2015 at 10:19 am
Viewing 15 posts - 2,086 through 2,100 (of 2,356 total)