Probably because you haven't specified the config file. Check out the documentation for dtexec - it'll show you what switch to use to point it to your configuration.

John

... but if I had to guess, I'd say you have numeric data stored in a varchar column. In test, all values in that column can be converted to...

I think log shipping started off as Enterprise only, back in the day, although it was possible to roll your own in Standard.

John

The only way I can think of is to execute sp_who2 when a potentially parallel query is running. If any SPIDs have eight rows, then your change has been...

Excellent. So that you're not drip-feeding information to us, please follow Phil's advice and post full table DDL and sample data.

Thanks

John

Edit - although I still don't think you've got...

So you want the student's attendance record for the class he or she is currently in? I'm not sure that's possible, because you don't appear to have anything linking...

You could run a trace or extended event or something to capture the SQL that is being run by Crystal Reports. Obviously this isn't going to capture stored procedures...

There's nothing in the properties of a stored procedure that says what it's used for. I'm not familiar with Crystal Reports - does it create stored procedures that have...

Well, if you're a domain admin, you should be able to log on to the domain controller, run the AD tools, and check that you are indeed a member.

John

You'd need to be a member of Domain Admins, I believe. I would strongly recommend that you plan to relocate this instance of SQL Server to a different computer...

As Steve said, you need to be a Windows admin, in other words, a member of the local Administrators group on the server. If you are, you'll be able...

Colm

Does your database have a case-sensitive collation?

Use DBName

SELECT *

FROM sys.sql_modules

WHERE UPPER(definition) LIKE UPPER('%searchstring%')

John

Colm

Just search in the definition column of sys.sql_modules. That'll cover stored procedures, views, functions, synonyms, triggers and so on, but not codeless objects such as tables and indexes. ...

You could output into a table variable, and only select it if there's no error. You might want to test for any effects on performance, especially if the stored...

How is your linked server configured to connect to the remote server? Right-click on the linked server, choose Properties and go to the Security page.

Are the two jobs owned...