Viewing 15 posts - 28,696 through 28,710 (of 39,771 total)
As suggested, talk to your network admin. They can help you determine why the copy takes so long.
May 5, 2008 at 10:04 am
The overhead depends on what you trace. Are you getting just login/logoff? Almost no overhead. If you want SQL statements, just get completed and the overhead depends on the load...
May 5, 2008 at 9:28 am
The article is incorrect and has been changed.
DAC is in Express with a trace flag.
May 5, 2008 at 9:25 am
MSDB works, but it's not reliable for reasons mentioned above (needs to be same server, can be purged, etc)
What are you trying to achieve?
May 5, 2008 at 9:23 am
Shaun,
Not to put you off, but this appears to be similar to an exam or homework question. If you show some work, we'd be happy to help.
Here's the basic idea:
you...
May 5, 2008 at 9:22 am
I'd suggest using the data export wizard, saving the package, and then adding the email task.
May 5, 2008 at 9:20 am
If you are in full mode, and you should be if this data matter, you need to be running regular log backups in addition to full (data) backups.
You should find...
May 5, 2008 at 9:19 am
no way to go back and do it. You have to be tracking this ahead of time.
Also, please post in the right version forum. Moved to SQL 2K forum.
May 5, 2008 at 9:18 am
xp_smtp?
Why not Outlook?
Without testing, the code looks ok and you're in the write approach. Have you tried doing this in VBScript first to check your object code?
May 5, 2008 at 9:17 am
Couldn't I go with bald-Ballmer look? I'm getting there on my own already.
Course I'm in a little better shape, maybe I'm the tan Ozzie/Ballmer morph! 😉
May 5, 2008 at 9:16 am
Please don't cross post.
Answered here: http://www.sqlservercentral.com/Forums/Topic495042-357-1.aspx
May 5, 2008 at 9:15 am
Are you manually copying? Check your network bandwidth, perhaps dedicate some ports to this task or a separate network on a switch.
May 5, 2008 at 9:15 am
Microsoft didn't really lose, it's that Oracle and DB2 grew at a faster rate, but SQL Server didn't. It was still growing, but few at 18.3% instead of 18.4 from...
May 5, 2008 at 8:42 am
That is not a compilation error. It's a run-time error when a conversion occurs. There are very few compilation errors, mostly syntax issues.
May 5, 2008 at 8:29 am
I put it as 3 because I think implicit conversions cause a lot of issues, waste time, and I see a lot of questions on these. So it's important.
I may...
May 4, 2008 at 9:50 am
Viewing 15 posts - 28,696 through 28,710 (of 39,771 total)