darn, sorry Michael, that...

well the commands to create and delete are like this:

but that's done via a command line...i'm not sure wehterh you'd do that in a script.

I've done it via xp_cmdshell before...

ouch.

so developers edit a procedure to manipulate data they are not supposed to touch, then put the original procedure body back to it's "normal" definition?

AND this is happening on Production?

wow.

my...

Are you editing the registry while SSMS is still open? i think it saves it's settings on exit, so you might be deleting the key, and closing SSMS re-writes the...

Error 1068: The dependancy service or group failed to start .

control Panel>>Administrator Tools>>Services:

sounds like the password for the user running the service might have changed, or was never set...

QQ-485619 (3/16/2012)

---

I have a table which has a column called Name, which contains the name of our vendors. The data format in this column is lastname, firstName. For...

glad it helped you out!

start with sys.indexes, and you have to join sys.index_columns and sys.columns

select

object_name(IDX.object_id),

IDX.name,

cols.name,

* from sys.indexes IDX

INNER JOIN sys.index_columns IXCOLS

ON IDX.[object_id] = IXCOLS.[object_id]

AND IDX.[index_id] ...

is the server an express instance , where remote connections are not enabled by default?

is it the default instance or a named isntance, and is the SLq broswer service running?

from...

it looks to me like the cost of SQL Server 2008 starts at around $3,000 dollars...well maybe 6K for a dual proc multi core, 12k for a Quad Proc multi...

weston_086 (3/15/2012)

---

Is this possible that i can have in this format 12/31/2099 .if we will do like

ALTER TABLE [dbo].[test] ADD DEFAULT ((convert(int,convert(datetime,'12/31/2099')))) FOR [id]. it will set default...

asc files are just plain old text files. open them up in notepad...you'll see the extension doesn't matter, the contents are plain text, the same way .txt files are.

well, you should store dates in datetime columns. you end up wasting a lot of time converting int values to dates and back again when it is not...

well in theory, you split the column on the space betwen the words...

but the issue is, "you cannot tell the which is the "middle" name between "James Tiberius Kirk" and...

my version, which accepts a dynamic number of words, splitting them by the space between words:

CREATE PROCEDURE [dbo].[CategoryName] @SEARCHSTRING varchar(1000)

AS

DECLARE @COLUMNNAME VARCHAR(128),

...