Viewing 15 posts - 28,771 through 28,785 (of 39,814 total)
They can claim anything. You could dispute it, but they might be able to narrow the definition to back up their claim.
What's the worlds largest database? Disk size? Rows? Trans/sec?...
May 1, 2008 at 10:19 am
There used to be issues with knowing the proper device sizes in 6.5 for some restores.
How is the server dying? Can you not add disks? That might be the easiest...
May 1, 2008 at 9:51 am
Please don't cross post: answered here http://www.sqlservercentral.com/Forums/Topic493712-19-1.aspx?Update=1
May 1, 2008 at 9:38 am
Not really. You could save each package as a VB file and search them or you can open each one.
May 1, 2008 at 9:38 am
Is this occurring in SQL Server? It looks like an Oracle error is bubbling back through.
My guess is that the create is getting sent through to Oracle and so it...
May 1, 2008 at 9:00 am
Go get the Management Studio express and install that. http://www.microsoft.com/downloads/details.aspx?FamilyID=c243a5ae-4bd1-4e3d-94b8-5a0f62bf7796&displaylang=en
Then you can see the databases listed.
May 1, 2008 at 8:55 am
Red GAte's tool (I work for Red Gate) only does databases, not servers.
ApexSQL has a doc tool, and there are a few more (SQL Scribe, etc, search SQL Server documentation...
May 1, 2008 at 8:53 am
First, do not type in all caps. It's shouting and rude.
Second, it's a temporary table. Using the incorrect verbage can confuse people.
Third, what doesn't work? what does "well" mean? Please...
May 1, 2008 at 8:45 am
I'd still be wary, though find out what's happening. The Volume Shadow Service, VSS, is supposed to work with SQL, but people have reported issues with it.
Not sure how well...
May 1, 2008 at 8:44 am
If this works, I'd do that. I have had issues at times with conversions and needed to go to the datepart function to get things to work.
select datepart( yyyy, datefield),...
May 1, 2008 at 8:41 am
There is a great XML series on this site by Jacob Sebastian. You might want to check it out and see if there are techniques in there that can help...
May 1, 2008 at 8:37 am
test, test, test.
Throw a load at the SQL Server, snap it, and then see if the other side is useable. There's always chance for an issue, but if you can...
May 1, 2008 at 8:36 am
Grant and Luke have good advice. I'll add one more: update your resume.
You might be the fall guy if this fails.
I'll pull for you and wish you good luck. There...
May 1, 2008 at 8:31 am
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
Viewing 15 posts - 28,771 through 28,785 (of 39,814 total)