After you get the optimal syntax run this proccedure through the profiler and then through the index tuning wizard to see if SQL Server has any suggestions for indexing. ...

I believe this information is in the sysprocesses table in the master database under the fiels "SID". But its a binary datatype so you'll have to do some digging...

Simple answer, because a checkpoint has not occured yet.

The DBA as a DB Developer is integral to the good design of an app, so DB Developers should always be part of a project. Admin DBA dont need...

Set up test boxes. Use test for learning. Don't do anything in Production until you fully understand and are completly confident of the changes you want to make to...

You dont want to change the owner to grant access for others. You want to add other users to the database users list.

do the following:

-expand database in question using...

Go To:

http://msdn.microsoft.com/library/default.asp?url=/downloads/list/dataaccess.asp

See the following section:

MDAC Utility: Component Checker Version 2.7

This release includes updated snapshots for MDAC 2.6 SP2 and 2.7 RTM. The Component Checker tool is designed to...

Simple way to view space used vs free space is:

Open EM

Right-click over the database in question

Choose View-->Taskpad

You will see the database and Log files at the bottom of the display.

Also...

Have you looked through the registry for references to the "OHIP.mdf"? I think the eror youre getting is related to MSSQL not seeing the correct .mdf. MSSQL thinks...

I think Microsoft made Great Plains use the SA by design not by default. GP goes into SQLServer as SA and does all kinds of "System Administrator" kind if...

Access denied can be a network rights issue. For instance, if you dont have write access to the directory where the .mdf or .ldf files are located you will...

Deek,

Are you trying to capture change history?

Isaiah

If you have many fields and only some of them are dupes you need another way to do this. Drop me a message and I'll show another method using...

Thanks Andy,

I was just starting to dg into this problem. I found the drive SQL was installed to was not allowing Write access. The access on this drive...

I like this, What's the final product (SQL Statement) look like?

Isaiah