Viewing 15 posts - 21,976 through 21,990 (of 39,936 total)
I don't think there's a best. Not sure for that level of precision that decimal v numeric matters. I wouldn't pick float or real, as it's not necessary.
October 25, 2009 at 9:43 pm
You might want to read this: http://www.yafla.com/papers/sqlhierarchies/sqlhierarchies.htm
This is hard to do in 2000. Easier in 2005 with CTEs and recursion.
October 25, 2009 at 9:41 pm
happycar59 is correct. You need to do these between servers of the same version. Even if it were possible (you could log ship), one you failed over, you couldn't fail...
October 25, 2009 at 9:38 pm
Have you setup replication before? If not, be sure you read about it in Books Online.
The publisher and distributor should be on 2000, but if you are just sending data,...
October 25, 2009 at 9:33 pm
I'm with ALZDBA. Use Enterprise Manager and don't worry about it.
October 25, 2009 at 9:28 pm
The SQL Server error log doesn't necessarily contain something to help you here. It might, but not necessarily.
Open Control Panel, data sources, create a new data source and see if...
October 25, 2009 at 9:28 pm
Thanks for the updated code.
October 25, 2009 at 9:26 pm
That's a great point. The cloud could be a private cloud, run completely by a company internally with their own staff. In that case, is there a reason not to...
October 25, 2009 at 9:23 pm
You can do this pretty easy in SSIS. Calculate the file name, change the destination dynamically based on the calculation.
October 25, 2009 at 9:21 pm
How did it fail? Any errors?
Check the sqlstp.log file on your drive. Or something close to that. Sort by time and look for it.
October 25, 2009 at 9:19 pm
Not necessarily. The leaf pages are moved, but not upper level ones. Potentially that means you could have fragmented intermediate pages that don't get cleaned up. I suppose, depending on...
October 25, 2009 at 9:18 pm
I'm with Barry. It's annoying, and a hassle.
However, with 2008, and some modern tools, intellisense makes this less onerous. no other disadvantages I'm aware of. I believe the name is...
October 25, 2009 at 9:16 pm
Please don't cross post. I am closing this thread.
October 25, 2009 at 9:10 pm
As Jeffrey mentioned, log size is completely dependent on the level and rate of activity. If you have users running in Simple mode, the peak may be smaller than in...
October 25, 2009 at 9:09 pm
How is security set? Is EXECUTE granted for the user? Or for a role the user is a part of?
Is EXECUTE denied anywhere, for the schema or procedure?
Public should...
October 25, 2009 at 9:04 pm
Viewing 15 posts - 21,976 through 21,990 (of 39,936 total)