Ever since I won the lottery, the only reason I hang out around here is so I can have friends....

try to avoid fields having the same name as their datatype; use a name that is more descriptof the purpose... like "entryDate" or whatever the field might mean to you.

when...

and to change compatibility in SSMS so you can test a specific statement:

ALTER DATABASE [SandBox] SET COMPATIBILITY_LEVEL = 80

GO

SELECT IDENTIFICATION, CREATE_DATE, CREATE_USER FROM CUSTOMER

GO

ALTER DATABASE [SandBox] SET COMPATIBILITY_LEVEL = 90

GO

SELECT...

sweet! glad that worked for you; I'm putting that in my notes that it really works; i wasn't absolutely sure.

yeah, getting the syntax for the dynamic sql part can be...

easiest way is from within SSMS via TSQL for me; the trace file will be open as if it were a table:

you might need to do select * from sys.traces...

in SQL 2000(the forum you posted in), i think it's a little tougher;

the easiest way to be to set up a trace on the server and check that after letting...

take a look at the posts in this discussion; it has a community contribution to script all indexes as CREATE INDEX statementing:

http://www.sqlservercentral.com/Forums/FindPost1079779.aspx

as far as the GUI goes, i think you...

wow this script has come a long way since the original version; thanks again to everyone who has contributed;

I cleaned up the formatting a little bit and added some comments,...

there is an additional caveat with that; when the driver scans the source for the rules on IMEX=1, it looks at the first 8 rows to decide the data size...so...

i believe this is a well known issue i'd seen with importing/exporting to excel or text files via the jet data providers. To overcome, you have to set the...

do you have a userId/name that is inherited fromt eh page you can use as a parameter? then you can order the data:

ORDER BY

CASE

WHEN SomeTable.AnalystID =...

i think the domain account needs to have launched excel at least once manually on the server itself, right?

the first time excel launches for a user, if there are not...

On a related note, I think this is how to check my current databases to see if any are owned by anyone other than sa, correct? so this doesn't occur...

i have this saved in my snippets on how to map a drive from xp_cmdshell:

exec master.dbo.xp_cmshell 'NET USE G: \\UNCPath\d$ /user:domain\user password'

GO

RESTORE Database DBName FROM Disk = 'G:\PAth to bak'

GO

EXEC...

Lynn on my roughly half a million row table i created with the data below, i get roughly double the performance with ITV vs scalar;16 seconds vs 9 seconds.

from...