thunderousity (8/24/2012)

---

... do these accounts need to be an AD Domain account or can I create local Server accounts for each service.

If I can create the local accounts, what are...

No. Such indexes are called Covering Indexes.

What you have written about NonClustered Index in confusing to me. So instead of commenting on that, I would ask you a question to encourage to do further research on...

Yes. It is still valid.

It's caled uniquifier.

Do you have enough free disk space?

Please run this script and post the output here:use <dbname>

go

select f.file_id, f.physical_name, g.name 'File Group', size/128 'Size(MB)', FILEPROPERTY(f.name , 'SpaceUsed')/ 128 'Space Used (MB)'

from...

I think SQL Server Browser service has stopped.

No. Cast/convert will not help here. You need to remove SUM() around database_name.

Evenafter that the query fails.

What are you trying to achieve? Other may help you to rewrite the query.

Yes. Lower version SSMS can be used to connect to higher version instances and execute SQL statements including any new syntax/statement.

I am not aware of any other method. Others might know.

Meanwhile you can ask the administrators to help in this matter.

Is the number of columns fixed/known like 3 as shown in the above example?

select j.name

from msdb.dbo.sysjobsteps s

inner join msdb.dbo.sysjobs j

on j.job_id = s.job_id

where s.command like '%SpTestProcedure%'

Job does not run under owner's account.

1) If you run a job manually, it runs using your login.

2) If schedule it, job runs using SQL Server Agent service account.

Are you taking backing to new file or adding to exisint backup file?

By default on the same machine Names Pipes protocol is used.

Disable Names Pipes or force TCP protocol.

Rollback happens in the memory and pages becomes dirty again.

Question of...