Viewing 15 posts - 35,776 through 35,790 (of 39,720 total)
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...
October 1, 2003 at 10:58 am
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...
October 1, 2003 at 10:56 am
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...
October 1, 2003 at 10:54 am
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...
October 1, 2003 at 10:53 am
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...
September 30, 2003 at 9:40 am
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....
September 29, 2003 at 2:47 pm
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...
September 29, 2003 at 2:42 pm
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/
September 29, 2003 at 2:41 pm
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,...
September 29, 2003 at 1:45 pm
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...
September 29, 2003 at 10:28 am
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/
September 29, 2003 at 10:25 am
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...
September 29, 2003 at 10:12 am
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/
September 29, 2003 at 10:08 am
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...
September 29, 2003 at 10:06 am
??
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
September 29, 2003 at 10:01 am
Viewing 15 posts - 35,776 through 35,790 (of 39,720 total)