Forum Replies Created
Viewing 15 posts - 35,776 through 35,790 (of 39,720 total)
-
RE: EXEC a DTS Package
I would use Phil's suggestion though you can build a batch file that calls DTSRUN with a a parameter for the package. The package could be on either the server...
-
RE: Long Wait times
Are you trying to determine what eats up the time for a query to return results to the client?
You've got IO, bandwidth on the network, rendering time on the client.
Steve...
-
RE: IAM Page Out of Range
I agree. PSS can help, but will likely point to hardware as the problem. These kinds of things can be very, very difficult to track down and could easily be...
-
RE: Date formats
I think you might want UTC date for the comparisons if you are getting data from 2 different time zones. But yes the time is calculated on the server.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The...
-
RE: Service Accounts Permissions gotcha's
BKelley has some good advice somewhere. Not sure if he wrote an article or if it is in an ebook he did, might check with him. Or send him an...
-
RE: Unavailable during restore
no way I know of. Better to write some check in there, perhaps add a table to some other database and mark this before a restore and unmark it after....
-
RE: Rolling forward
When you restore the full, you have to specify the "with norecovery" or with "standby" options. Then you can load t-logs. Need to be sure you do not complete recoery...
-
RE: Using OpenXML to import into SQL 2000
create procedure spTest
@txt text
as
select @txt
go
Try this for the variable of the OpenXML part.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
-
RE: Where Do I Want To Go Today? - Rich Data Types
Thanks for the note. I haven't really worked with Site Server.
I'd like to see some of this in the core product, or as an option for SQL Server itself. Images,...
-
RE: SQL 6.5 trace log
Anytime. Good luck and come back and let us know what you find. Or better yet, write it up and send us a short article
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The...
-
RE: SQL mail
Either get an account that can authenticate or change to SMTP.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
-
RE: Active Directory Group Membership
I'm not that great at this, but I think you'd need to query the ADSI provider using LDAP and get a collection of the group's members.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of...
-
RE: Victim Resource Owner
What's the exact error? Is this because of a deadlock?
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
-
RE: Test/Production/QC Environments
I haven't tried this, but youmight be able to use the Red Gate tools (see the bottom banner ad) to move the strucutre and then a subset of data over.
Steve...
-
RE: Randomize
??
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
Viewing 15 posts - 35,776 through 35,790 (of 39,720 total)