Viewing 15 posts - 36,406 through 36,420 (of 39,771 total)
You can't do this AFAIK. This really is looking for stored procedures. Alteratively you could probably script something that could take the parameters and submit some dynamic sql.
Steve Jones
April 17, 2003 at 10:59 am
Great advice from Brian and I totally agree with choosing your strongest subject first, it will reduce the tension. I'd also plan on working over a short period of time...
April 17, 2003 at 10:56 am
When you say schema do you mean just the columns? Or do you need other information?
select * From information_schema.columns should help.
Steve Jones
April 17, 2003 at 10:51 am
you need a table datatype to return to. Or a temp table. You can do an
insert MyTable exec spOne
as well to get a result set into a table.
Steve Jones
April 17, 2003 at 10:49 am
SQL Server will stabilize at some point, but it usually expects and likes to be the only app on the server. Is this a shared server? Other applications running?
How much...
April 17, 2003 at 10:44 am
Great idea. We want more demographics. Interesting to some people, but advertisers love it. Helps us keep the community growing.
One issue is that we get relatively few responses to...
April 17, 2003 at 10:41 am
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
Viewing 15 posts - 36,406 through 36,420 (of 39,771 total)