Viewing 15 posts - 28,741 through 28,755 (of 39,771 total)
That's not the worst plan, although it things don't work you'll have an extended outage while you remove 2005 and reinstall 2000.
Be sure you keep backups of the 2000 databases...
May 1, 2008 at 8:28 am
SUBSTRING and PATINDEX/CHARINDEX can split things out, but you need to have some sort of pattern.
Also, if there are a variable number of items in the 2nd column, there's no...
May 1, 2008 at 7:48 am
You could use OPENQUERY as well.
May 1, 2008 at 7:47 am
He's wrong. The mdf/ldf files are always open with the SQL Server service, so they aren't backed up by most programs. Even an open file backup program can get into...
May 1, 2008 at 7:46 am
The database is probably Events. Events.mdf would be the data file for this database and there will be an Events.ldf that contains the log, both of which make up the...
May 1, 2008 at 7:45 am
There are plenty of databases that are in the TB range because they have that much data. Going to a different architecture, especially with views, doesn't buy you anything. You...
May 1, 2008 at 7:17 am
You bring up some good points about new devices, but keep in mind one thing. The Kindle isn't designed to be a computer. It's designed to compete with books...
April 30, 2008 at 3:49 pm
I leave my computer on, but it shuts down after about 20 minutes, including the dual LCDs that power-save. The printer shuts down and takes a couple minutes to wake...
April 30, 2008 at 1:03 pm
Lee,
I haven't done a lot of work with this, but when there's a failover, the mirror becomes the principal and the principal is the downed mirror. There is a...
April 30, 2008 at 1:01 pm
The half.com idea doesn't really suit me as I won't sell them back. The 1/2 price doesn't really make a difference to me and it's a pain to sell back....
April 30, 2008 at 12:57 pm
The client needs SQL Server. You can use SQL Express (2005) or MSDE (7, 2000), but an MDF file isn't opened by the app. There are .sdf files opened...
April 30, 2008 at 9:16 am
I don't think that you can get this to run without some rights. Possibly serveradmin or processadmin rights can let you see this, but someone would need to give you...
April 30, 2008 at 9:15 am
VMs work great for studying, but I'd recommend and external USB drive to share the load with your built in drive.
The VMs are alike, so clustering works great.
April 30, 2008 at 9:12 am
I bet that Sa is a special case and you can't allow someone to elevate their privileges to this level, even with EXECUTE AS.
What about just creating a dummy account...
April 30, 2008 at 9:10 am
Not an authoritative source, but some of the less-busy people at Wikipedia show some savings.
April 30, 2008 at 9:08 am
Viewing 15 posts - 28,741 through 28,755 (of 39,771 total)