Thanks Aakash, great article, and it provided the breakthrough I was looking for to migrate our existing performance baseline capture using SQL Trace, wrapped in stored procedures, to using XE. ...

Thanks for the reply, Daniel. I came up with the solution...

Whilst I didn't use your solution, it prompted me to rethink how I format the data coming back from...

Thanks Brian, Carl,

Using a combination of the information that you provided, I realised that what I wanted to do was as simple as:

CREATE USER [Reports] FOR LOGIN [Reports] WITH...

Hi msuarez

I am also seeing similarly named stored procedures being created when I apply a snapshot after configuring transactional replication. They also appear when adding articles to an existing...

Hi Crispin,

Firstly, to answer your question, "Compact db" simply runs the MSAccess .exe from the command line on the server with the option to compact the .mdb file.

Now, your...

Hi, The dashes indicate the size of the column of data that you are working with, and the number of dashes will vary depending on the datatype and size of...

I had a requirement recently whereby I had to set up a job that generated scripts to recreate existing user views, functions and stored procedures.  The reason for this in...

Hi Tim,

Thanks for the reply.

BUILTIN\Administrators still exists on the instance, although I don't like the fact that it's there.  According to the MS white paper on FTS, this account...