The column size describes the amount of pages that the file has. Page's size is 8K so if you multiply this column by 8, you get file's size by...

You can check with the objectproperty function if the trigger is disabled. Also notice that your trigger won't handle correctly cases where you insert more then 1 record into...

In that case this is the problem. You can pass it a parameter for @rowcount or you can modify the procedure, so it won't have this output parameter.

Adi

You didn't write how you run the procedure, but it looks like you don't pass it the output parameter. When you use the procedure do you pass to it...

If you want it to be truly dynamic and decide on the column's name during runtime, you can do it with dynamic code. Notice that dynamic code has its...

I've done it with one of the databases. You have to remember that you also can't use any statement that modified data on the view. In my case...

I have to admit that I don't know how come there are records that don't show the host names. Can you see the application's name and user's name...

You can do it also with an Inner Join:

create table #MasterDates (D DATE)

go

insert into #MasterDates (D) VALUES

('2014-08-01'),

('2014-08-02'),

('2014-08-03'),

('2014-08-04'),

('2014-08-05'),

('2014-08-07'),

('2014-08-09')

go

create table #Employees (EmployeeID char(6), StartDate date, EndDate date)

go

INSERT INTO #Employees (EmployeeID, StartDate, EndDate)

values('003505',...

TDE will only help if some stills the database's files or the database's backup files. The data is written to those files with encryption, but when it goes into...

You have to get rid of each GO in your code. The word GO is used by the SSMS as a batch separator. This means that you now...

phingers (9/2/2014)

---

Thanks, that works great on my sample data, but when I try it against the real table with more rows it returns the following error:

The maximum recursion 100 has...

There is a very good chance that there is a better way of doing it, but here is one way:

declare @MinDate datetime

declare @MaxDate datetime

--Getting the first and last dates in...

The profiler has the columns Application Name, Login Name and Host Name. You can use them to figure out from which application, login and machine any statement came from....

The fact that you have other backups to the same network drive, doesn't mean that this cannot be a permission problem. For example in many places you can't backup...

Well, that changes the situation:-). Bellow is an Xquery that I think that it does what you need. Have a look and let me know

declare @xml xml =...