Viewing 15 posts - 36,361 through 36,375 (of 39,720 total)
No double post, and let me tackle the comments in reverse.
Bill, I tend to agree on the versions supported, but as I mentioned we'd just gon on what the vendor...
April 14, 2003 at 2:11 pm
sp_helpdb also has the information for all dbs.
Steve Jones
April 14, 2003 at 9:49 am
I know it's a lot of work, but I was trying to trade more work for a known format, which hoepfully would make it easier.
Good points about rating as a...
April 14, 2003 at 9:46 am
Can you change the writeline within the loop to just write the query result and not the "put", etc.
Do you get any writes from the function?
Steve Jones
April 11, 2003 at 4:46 pm
I wouldn't necessarily run this on every server, but those that are giving me problems I would have this ready and set it up.
Steve Jones
April 11, 2003 at 10:13 am
There are a few articles on this site for moving databases. Check them out:
http://www.sqlservercentral.com/columnists/ckempster/deattachandreattachdatabases.asp
http://www.sqlservercentral.com/columnists/awarren/20010425205439_1.asp
http://www.sqlservercentral.com/columnists/rsharma/copydatabase.asp
Steve Jones
April 10, 2003 at 10:35 am
Are you recieving any values here? you might try checking the filemon (www.sysinternals.com) and see if there are physical files being created.
Steve Jones
April 10, 2003 at 10:22 am
Can you run an sp_who2 and see if there are any connections that are not "sleeping". If so, run a dbcc inputbuffer with the spid value and be sure someone...
April 10, 2003 at 10:08 am
Standards are important, mainly to make things easy to find. We've got 60+ SQL Servers, 30 of which I manage. We have a standard hardware setup, 3 physical arrays min...
April 9, 2003 at 11:06 am
only 2 references in BOL. One for the number created per sec, the other seems to link to the Index TUning Wizard. perhaps the server creates files when testing new...
April 9, 2003 at 10:54 am
What do you mean by secure? Security involves the web site setup (need an admin book), SQL setup, good books and advice on the site, and good development practices.
A few...
April 8, 2003 at 1:04 pm
Does dbo exist in all of your database user collections?
Steve Jones
April 8, 2003 at 12:56 pm
Also log in as the SQL Server account, start Outlook (or your mail client) and send mail. Do any dialogs pop up? Or is there some other "funny" thing about...
April 8, 2003 at 12:55 pm
Wow, that's quite a setup. Not sure you'll get an answer here, but good luck. We're primarily for databases, though there are a few good network people here.
Steve Jones
April 7, 2003 at 3:08 pm
Viewing 15 posts - 36,361 through 36,375 (of 39,720 total)