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...

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...

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,...

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

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...

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...

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...

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...

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...

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...

If you are using the IMPORT or EXPORT functionality from Enterprise Manager,it might be because you are using the default options:

If you used Right click>>All Tasks>>Import Data (or Export data)

Then...

Thanks for the reply Hans;

This has been kinda educational for me.Here's what I had assumed:

a database is open or closed depending on the autoclose option of the database....so on a...

you just concatenate the fields with the hardcoded stuff;

update tablename

set email = fname + '.'+ lname + '@domain.com'

here's a substring example in case you wanted first initial + lastname:

update...

I'm not sure if this will work, but what about this:

--edited to add an inner join to get the staff id's  last tip

CREATE PROCEDURE [dbo].[prc001GetTipOfTheDay]

 (@intStaffID int)

AS

Select Top 1...

Here's my answer ot the second half of your question:

a text column is used when you have data that is going to be really big; a varchar has a max...