Viewing 15 posts - 8,536 through 8,550 (of 9,241 total)
danchard (6/30/2008)
I wanted to enter server name/instance name
the correct syntax to use is
servername\instance
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 7, 2009 at 2:52 am
check your index widths too, depending on the columns included indexes can be quite large
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 7, 2009 at 2:49 am
also instead of re creating and syncing the logins use the following link
http://support.microsoft.com/kb/246133
to move logins between servers, preserving the database to user relationship
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 6, 2009 at 4:48 pm
Jeff Moden (1/6/2009)
Crud... I was just reaching for the bucket o' fresh pork chops... 😛
ha ha, i was wondering if this post would catch your eye Jeff.
foxjazz (1/6/2009)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 6, 2009 at 4:28 pm
rons (1/6/2009)
but would like to see the differences between the 2 tables in one result window.
then use the correlated query Ninja supplied above
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 6, 2009 at 2:17 pm
foxjazz (1/6/2009)
And you can still use c# it's easier to do this in a valid programming language than t-sql because it's easier to debug.
OK, now is time to leave the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 6, 2009 at 2:02 pm
foxjazz (1/6/2009)
it's probably easier to use a cursor to iterate through your first table.
well deserving of a pork chop this one 😀
a simple select with a correlated sub query will...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 6, 2009 at 1:49 pm
Ells (1/5/2009)
1.The data warehouse has simple recovery mode so I dont believe this will have an issue as the database is backed up weekly before a load is performed.
under simple...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 6, 2009 at 1:15 pm
can you post details of the job steps?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 6, 2009 at 1:02 pm
Mani (1/6/2009)
I used windows authentication.
doe this machine belong to a windows domain, supply more info please
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 6, 2009 at 12:47 pm
GilaMonster (1/6/2009)
Got a backup?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 6, 2009 at 12:41 pm
personally i'd burn them to separate disks
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 6, 2009 at 12:37 pm
option 1 is the native client update, option 2 is the full monty 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 6, 2009 at 12:36 pm
usually a repair of the .NET 2 framework is enough did you try that at all in your previous steps
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 4, 2009 at 10:28 am
madhu
your service account does not need domain or machine rights as they are automatically assigned by the setup program or sql config manager. A series of local groups get created...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 3, 2009 at 12:15 pm
Viewing 15 posts - 8,536 through 8,550 (of 9,241 total)