Viewing 15 posts - 8,551 through 8,565 (of 9,253 total)
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)
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
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...
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...
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...
January 6, 2009 at 1:15 pm
can you post details of the job steps?
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
January 6, 2009 at 12:47 pm
GilaMonster (1/6/2009)
Got a backup?
January 6, 2009 at 12:41 pm
personally i'd burn them to separate disks
January 6, 2009 at 12:37 pm
option 1 is the native client update, option 2 is the full monty 😉
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
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...
January 3, 2009 at 12:15 pm
releasing space can be wasteful of resources. Space in the file wil be required to carry out the action, so it'll only grow again and have you going round in...
January 3, 2009 at 11:53 am
Gail, who knows i'm with you on this!
BTW happy new year 😉
December 31, 2008 at 8:13 am
Daksin
as Adi pointed out you cannot query the database in the norecovery state. Bear in mind with the standy option when log file restores occur users will be kicked out...
December 31, 2008 at 8:11 am
Viewing 15 posts - 8,551 through 8,565 (of 9,253 total)