Viewing 15 posts - 1,816 through 1,830 (of 2,486 total)
There is a style called Formatted that puts in <PRE></PRE> tags, but it seems to do on a line by line basis. In the old forums you used to be...
February 19, 2004 at 6:01 pm
Chris
The forum formatting for code isn't what it used to be, but they'll get there. That's one of the things that makes this a great site.
It also seems to have...
February 19, 2004 at 4:40 pm
Even better, write the message to a table in the database. That way you can produce reports on what was done, when and how often.
February 19, 2004 at 3:33 pm
I've had experience with a quad P3 500mhz out doing a dual P4 2.8ghz. This was mainly due to application and database design though. Some of the queries where horribly over...
February 19, 2004 at 3:31 pm
Forget temp tables and the like. Here's what I run every 5 minutes on the server.
INSERT INTO dbo.tblActivityLog ( SPID, LastUpdate, Status, Login, HostName , BlkBy, DBName, Command, CPUTime, DiskIO , LastBatch,...
February 19, 2004 at 3:00 pm
Ah Ha ... where did you find out about the parameters for xp_dirtree?
February 12, 2004 at 8:55 pm
The execution status comes from sp_get_composite_job_info which in turn comes from xp_sqlagent_enum_jobs.
February 12, 2004 at 8:45 pm
Try any of the ASP/Dev webistes.
http://www.asp.net http://www.15seconds.com/ http://www.4guysfromrolla.com/
etc...
February 12, 2004 at 7:28 pm
I would remove QA from the users and give them an ASP page. From this page they could launch and monitor the process.
Less chance of things going haywire because the...
February 12, 2004 at 6:49 pm
The copy SQL Objects task will BCP the data out to a text file, truncate the source table and then BCP the data back in. This happens for each selected table in...
February 11, 2004 at 3:56 pm
You could still use something similar to Noeld suggestion, just use OPENQUERY instead of OPENROWSET. Then you can use a linked server. A server can have a linked server that refers...
February 11, 2004 at 3:25 pm
It's nothing to do with the join syntax. In an outer join query, you can't specify criteria in the where clause for the table on the opposite side of the...
February 10, 2004 at 9:19 pm
Firstly I don't know why you convert your date parameter to datetime then back
to nvarchar. Why not just use the passed value as it is?
In the statement where you convert...
February 8, 2004 at 5:01 pm
More CPU power so the process completes quicker, more memory so SQL Server can cache more data, faster Disk I/O subsystem to process reads/writes faster.
Naturally any of these will require...
February 5, 2004 at 2:07 pm
Well the sample I provided didn't check the return value from the sp_OA* procedures. The variable @hr will be zero if there were no errors. If you find an error,...
February 5, 2004 at 2:02 pm
Viewing 15 posts - 1,816 through 1,830 (of 2,486 total)