Viewing 15 posts - 13,381 through 13,395 (of 13,419 total)
As far as I know, the ONLY way to save your xml is using an application stream for SQL 2000. SQL 2005, with it's more robust XML support, may offer...
March 8, 2005 at 6:31 am
apparently a hind_ can be either a hypothetical index or a hypotehetical statistic; note how the tweak the dynamic sql based on the objectproperty:
from the same MS KB article:
DECLARE @strSQL...
March 2, 2005 at 3:28 pm
i found out that hind_ items are hypothetical indexes that are used by the index tuning wizard, they are supposed to be auto-removed when the tuning is done; see:
http://support.microsoft.com/kb/293177
The...
March 2, 2005 at 1:35 pm
Remi's knowing the nuances of allowable indid and status values lets him use that to find the drop statements; you'd still have to wrap that into a cursor to get...
March 2, 2005 at 11:47 am
The script below uses a cursor nested within a cursor to get the job done.
in this case it drops ALL statistics, leaving indexes alone.
SET NOCOUNT ON
--ONE OF THOUSE HORRIBLE...
March 2, 2005 at 10:32 am
how can an index be proprietary? any index created on a table will show up using sp_helpindex <tablename>, right? any index created can be scripted out, and the same goes...
March 2, 2005 at 7:17 am
The datetimepicker exhibits a similar problem from vb6; when there is no date, I wanted it to be blank...i think it defaults to current date.
In vb6, this trick will hide...
February 23, 2005 at 6:13 am
If you are able to logina s one of the BUILTIN\Administrators, you can simply change the sa password to a new password.
Also, I believe by reinstalling SQL Server from CD,...
February 18, 2005 at 6:13 am
http://vyaskn.tripod.com/code/generate_inserts.txt
a stored procedure which generates insert statements, complete with IDENTITY_INSERT ON/OFF for the primary keys, and lots of parameters to make it flexible.
HTH
February 3, 2005 at 6:53 am
Steve Jones added this script ot the library, and I use it occasionally;
it kills any spids that have been inactive longer than the # of seconds parameter you pass the...
February 3, 2005 at 6:05 am
there is a handy UDF function called SPLIT on this site that I use for this purpose;
http://www.sqlservercentral.com/scripts/contributions/835.asp
it accepts two parameters, the text and the delimiter to split the text...
January 12, 2005 at 6:12 am
Actually, i figured out a different way to get the totals; rather than using that subquery to get the count, i'm using a group by to count case statements, which...
December 3, 2004 at 10:44 am
It sounds like you could use regular expressions to strip out the html;
on codeproject.com (http://www.codeproject.com/managedcpp/xpregex.asp) there is an extended stored procedure which is basically a wrapper...
November 22, 2004 at 6:02 am
I'm slowly growing here.....
my issue was the provider in the connection string...i had assumed that the provider I currently use, SQLOLEDB /SQLOLEDB.1 would work for all versions of SQL; it...
November 10, 2004 at 8:20 am
In theSQL Computer Manager>>Server Network Configuration, for Server Protocols, I had additionally enabled the "Via" selection. disabling this setting allowed my instance to start, and I can connect to it...
November 9, 2004 at 12:59 pm
Viewing 15 posts - 13,381 through 13,395 (of 13,419 total)