Viewing 15 posts - 2,071 through 2,085 (of 2,339 total)
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...
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...
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
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"...
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/
March 12, 2015 at 4:53 am
below86 (3/11/2015)
CELKO (3/11/2015)
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?...
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...
March 6, 2015 at 9:32 am
Yes. This will work.
The simplest solution is usually the best solution.
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...
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...
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...
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...
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...
March 5, 2015 at 10:19 am
Qualify what the problem may be is the first step.
Did it just start? Is it some users, or all users? Is it some queries, or all queries? Is it...
March 4, 2015 at 10:29 am
Viewing 15 posts - 2,071 through 2,085 (of 2,339 total)