If you haven't change the standard installation for logs, it would be the errorlog file in the log directory under the mssql directory. Also you can look in...

To find out the line in QA for a given statement do this:

1) Place you cursor on a statement in QA for which you want the line number

2) Then look...

Are you really sure you want to give a web user SYSADMIN permissions? I think I would have picked BULKADMIN role. I don't put anyone in SYSADMIN except...

Is the users a member of the sysadmin or bulkadmin role? It is my understanding that the user needs to be in one of these roles to execute BULK INSERT....

Not sure exactly what your problem is, but if I was to write a procedure similar to what you want to do it would look something like this. Hope...

Here is something that might help. This example select one order per store. The order selected happens to be the newest/most recient order. Possibly can can use...

Gee possible MSSQLCrack might be useful to find out that sa password. You might consider reading the following article by Steve Jones:

http://www.sqlservercentral.com/columnists/sjones/reviewmssqlcrack.asp

-------------------------

If you looking for SQL Server Examples check...

Does the errorlog file in the log directory contain any information to help you determine why you might be abnormally terminating.

-------------------------

If you looking for SQL Server Examples check out my...

Any error messages associated with the abnormal termination?

-------------------------

If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

Basically I'm guess you would like to have a record based on the checkboxes a person selects. I'd like to suggest you implement a relational design where you have...

Try this out......

-- mm/dd/yy format

select convert(char(8),getdate(),1)

-- mm/dd/yyyy format

select convert(char(10),getdate(),101)

-------------------------

If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

quote:

---

How do I format the result returned by getdate() into mm/dd/yy format?

I've gotten as far as:

PRINT CONVERT(DATETIME,GETDATE(),101)

but that gives me the time...

A database is in LOAD status when you are in the middle of restoring it. Typically this occurs when you are restoring from multiple backups (full, differential, and transaction...

I'm guessing you mean the trailing spaces behind the table names. If so would something like this work for you:

declare x cursor for

select TABLE_NAME from INFORMATION_SCHEMA.TABLES where TABLE_TYPE='BASE...

I think I might consider generate a T-SQL scripts in EM to generate a listing of all stored procedures.

Would that work for you?

-------------------------

If you looking for SQL Server Examples check...