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...

So are you saying that if you go to the SQL Server instance on which the jobs run and run the following two queries, the first will return results but...

RESTORE LOG MyStandbyDB

FROM DISK = '\\MyServer\MyShare\MyFolder\MyFile.bak'

WITH RECOVERY

John

Any constraints, triggers and indexes on a table are removed when you drop the table.

John

Although if the package fails, the job step will fail. However, the package won't necessarily fail just because one or more components in it do. That will depend...