Viewing 15 posts - 35,071 through 35,085 (of 39,723 total)
Not that we're the most dilligent, but we don't have any real information about anyone on this site (no SSNs, credit cards, etc). Any billing we do for http://www.sqlserverstandard.com is...
March 26, 2004 at 9:34 am
Thanks. Glad that after a year or so, this stuff still applies.
March 25, 2004 at 3:52 pm
Can you post the code? What does the proc do? This is usually when a connection cannot find the server. Are you sure you have a connection at this point?
March 25, 2004 at 9:55 am
If you login as the SQL Server Agent account and run EM, does it still run? It's a connection problem of some sort. It's like the source server isn't running...
March 25, 2004 at 9:54 am
Wow, you're asking a tough one. Not sure how much there is on the web. Swynk used to have some stuff, might search there (it's not dbjournal or something).
I do...
March 24, 2004 at 2:21 pm
Yes and no. Some sites want to hold the copyright. We don't. Not sure about SSWUG. We do ask that you do not submit anywhere else for 90days if you...
March 24, 2004 at 2:15 pm
Are you looking for a "row number" type thing?
http://www.sqlservercentral.com/columnists/glarsen/sequentialnumbering.asp
March 24, 2004 at 9:48 am
Andy Warren, Brian Knight, and Steve Jones run this site. Steve Wynkoop runs sswug. We know each other, but that's it.
sswug is an aggregator of content for the most...
March 24, 2004 at 9:45 am
Run profiler and see exactly what is happening. Also perf mon to be sure that SQL has enough memory, CPU not stacked, etc. Brian Kelley has a great performance tuning...
March 23, 2004 at 10:37 am
Use the same technique as this thread:
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=107483
More about it here:
http://www.sqlservercentral.com/columnists/sjones/batching.asp
March 23, 2004 at 10:34 am
CASE statement,
sorry ![]()
March 23, 2004 at 10:22 am
Why do you need this functionality? I've got a package that checks the backup path and if it doesn't exist, creates it.
select @cmd = 'exec master..xp_cmdshell ''if not exist '...
March 23, 2004 at 10:15 am
Never tried this and not sure it will work. Typically I've opened and resaved each on the new server. Or exported to flat file (.dts) and then imported.
March 23, 2004 at 10:13 am
I think this broke when we converted teh site. I'll mark it as a bug to work on. In the meantime, here are a couple links:
DTS: http://www.sqlservercentral.com/columnists/sjones/sqlserverdtsresources.asp
DMO: http://www.sqlservercentral.com/columnists/sjones/sqlserverdmoresources.asp
Licensing:...
March 23, 2004 at 9:41 am
Viewing 15 posts - 35,071 through 35,085 (of 39,723 total)