ID Name LoggedTime In/Out

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

001 Alen 9:00 I

002 Alice 9:43 I

001 Alen 9:49 O

003 Bitchel 9:54 I

002 Alice 12:03 O

003 Bitchel 12:04 O

The required result is like this.

ID...

I'm not sure I understand your question or your post at all.

I think you have 2 procedures, each of them returning a result.

You want a result that unions the...

Additionally, have a look at the system tables dbo.sysjobs and dbo.sysjobhistory in the msdb database. Query for your replication jobs.

You can query the table dbo.msdistribution_history in the distribution database.

Have a look here: http://msdn.microsoft.com/en-us/library/ms179878.aspx

I don't know any functionality that really replaces the try-catch. If an exception occurs...

I'm not 100% sure but I think it is the following: If you have a tape and use it for backup, and there is another backup file on it, that...

Thank you for your answer 🙂 I already read the site you suggest. Unfortunately this gives me no information about how handling of large files while affect the whole system...

thank goodness someone else tries, I dont' find a solution yet...

You could either have a look at the sql server log, that contains the information THAT a deadlock occurs.

In our system, for example, the applicaton writes any exception into a...

hi,

I tried to understand your example but I didn't.

I have no idea how you get to the date values for the added rows. And what about the first row...

You seem to know THAT and also WHEN you had a deadlock.

Active the trace flag 1222 on the server. If a deadlock occurs you can find a lot of useful...

hi,

I think it is possible.

It depends on whether your users are Windows-Users or SQL-Logins.

If Windows-Users: you can create the 3 groups you require in windows active directory and then add...

hi,

yes, you can query msdb-database. There are some system tables there. At the end there are two selects for getting the most important information. All the tables are described in...

Have a look at the dateadd()-function.

For more detailled answer, as Ed Wagner said, more details are required.

What do you mean by setting NOCHECK? Please post the full statement 🙂