Viewing 15 posts - 7,171 through 7,185 (of 9,728 total)
I'm not really good with the scripting code, but I have an alternate suggestion. 2, actually.
Pull the data into a temp table with an identity field and then use that...
October 19, 2010 at 11:08 am
John Rowan (10/19/2010)
Let's see...things to do near Omaha.Besides that, Omaha has an outstanding Zoo.
Henry Doorly (sp) Zoo. Beautiful place.
Fontinelle Forest (for hiking)... Lots of huge parks in the area....
October 19, 2010 at 10:31 am
crookj (10/19/2010)
Garden of the Gods
Been there. Beautiful place.
October 19, 2010 at 10:26 am
Marv-1058651 (10/19/2010)
October 19, 2010 at 10:25 am
That right there might be the problem. I don't know if SQL Agent is actually needed for the install, though.
October 19, 2010 at 10:23 am
I would just like to let everyone know that I live very green.
My sheets are green, my clothes are green, my food is green, my cats are green... Oh, wait....
October 19, 2010 at 10:21 am
davidandrews13 (10/19/2010)
Brandie Tarvin (10/15/2010)
A job where the Dev instance was on the same server as the Production Instance. SQL Security was not...
October 19, 2010 at 10:18 am
Roy,
What is it deadlocking?
What exactly is the question? @=)
October 19, 2010 at 10:13 am
Is there a difference between the service accounts used for the other instances and this one?
If so, are you sure the accounts have the necessary permissions for installation?
October 19, 2010 at 6:49 am
Brandie Tarvin (10/19/2010)
GilaMonster (10/19/2010)
Help me do the impossible: http://www.sqlservercentral.com/Forums/Topic1006743-357-1.aspxAdded in a second penny. Hopefully that'll equal two cents worth.
And he seems to have responded well to all our responses. He's...
October 19, 2010 at 6:32 am
GilaMonster (10/19/2010)
Help me do the impossible: http://www.sqlservercentral.com/Forums/Topic1006743-357-1.aspx
Added in a second penny. Hopefully that'll equal two cents worth.
October 19, 2010 at 6:21 am
In addition to the maintenance plans listed above, you should also code a job that checks file sizes verses available disk space to make sure you aren't running out of...
October 19, 2010 at 6:19 am
A few notes. Use Truncate instead of Delete. Truncate logs only the extents being deleted, not the entire record like Delete does. Hence, it's quicker. Also, be aware that using...
October 19, 2010 at 6:12 am
Quick note that has nothing to do with resolving your problem, but could save you a lot of typing. You don't have to Declare each variable on a separate statement....
October 19, 2010 at 5:49 am
The only thing I can think of at this point is either that the GUIDs already exist in the table that you're trying to load the Excel sheet into or...
October 19, 2010 at 4:31 am
Viewing 15 posts - 7,171 through 7,185 (of 9,728 total)