Viewing 15 posts - 1,996 through 2,010 (of 6,216 total)
#2. No way I'd want to take my service down nightly, and no reason to as far as Im concerned. Definitely a good idea to back up to disk and...
June 26, 2003 at 7:29 am
Its from a maintenance plan - try running select * from sysdbmaintplans.
Andy
June 26, 2003 at 7:06 am
If you have replication set up it won't let you detach, you have to drop replication first.
Andy
June 26, 2003 at 5:11 am
June 25, 2003 at 5:22 pm
Haven't tried, but it should work as long as you have rights to use xp_cmdshell. Syntax should be xp_cmdshell 'wscript whatever.vbs', I think.
Andy
June 25, 2003 at 3:58 pm
If you can use an ODBC driver to access it, sure (well, probably!). Set up a linked server, or you could use openrowset.
Andy
June 25, 2003 at 3:57 pm
Tried profiling to see if it's trying to connect and failing, or just not hitting the server at all? Which authentication type are you using - sorry I have not...
June 25, 2003 at 3:55 pm
I went to Teched this year, about $1200 if you signed up early (they have have an MCP discount). Lots of developer topics, very well managed conference, worth attending in...
June 24, 2003 at 2:40 pm
I like the theory of fkeys, but in practice I rarely define them. I work in a fairly fluid environment that is also replicated, removing the fkeys makes it easier...
June 24, 2003 at 2:38 pm
Same service packs and hot fixes? Run sp_updatestats?
Andy
June 24, 2003 at 12:31 pm
No idea. Kinda overwhelmed at the idea of actually returning 70 million rows - what do you do with them? You could try just returning a subset and extrapolating from...
June 24, 2003 at 10:42 am
On the money. One thing I'll add is that it doesnt have to be the physical name, it could be a DNS or WINS alias as well.
Andy
June 24, 2003 at 8:52 am
Just treat it as a derived table, like this:
select * from (your query here) as a for xml auto.
Remember to alias any aggregate columns in your group by.
Andy
June 24, 2003 at 8:51 am
The PASS conference is very worthwhile. Not as sold on the value of the web site - but I might be biased!
SSWUG - again, I'm biased, but I see little...
June 24, 2003 at 8:46 am
Viewing 15 posts - 1,996 through 2,010 (of 6,216 total)