http://sqlblog.com/blogs/tibor_karaszi/archive/2009/09/19/sql-server-agent-jobs-and-user-contexts.aspx

SriSudha (6/12/2013)

---

Hi,

Please help me,

In my table have a one date column. It contains data in different formats .I want to set all these...

INSERT INTO

dbo.Logtable (AdditionalInfo)

SELECT

'Another Process with ID: ' + CAST(ID AS VARCHAR(25)) + ' is currently in use')

FROM

[CBH]

WHERE

[SID] = 2;

INSERT INTO

dbo.Logtable (AdditionalInfo)

SELECT

'Another Process with ID: ' + CAST(ID AS VARCHAR(25)) +...

I also use Visio for reverse engineering database models. The Database Diagram will change your objects, however if you need to use it then you can restore your database onto...

Do you have any database documentation?

Lucky9 (6/13/2013)

---

trying to fine tune a stored procedure

it has 10 union all between select scripts..performance is very slow...what is the alternate for union all..

and all the select statements have derived...

Password protection of zip files is a function of the zip software you use before sending the email.

How wide is your clustered index.

Can you supply DDL for the clustered index and for the suggestion.

You really should not change system stored procs at all. For one, any...

That is not a user defined system proc.

http://msdn.microsoft.com/en-us/library/ms403828.aspx

EXEC msdb..sp_send_dbmail

@recipients = '',

@subject = '',

@body = '',

@file_attachments = 'C:\my_csv.zip';

It only performs reasonably well in the UK 😉

Think of it this way.

Pretend that the replicated server is hosting your companies timesheet...

GilaMonster (6/12/2013)

---

Index rebuilds don't move the LOB data. Just the index b-tree.

The only two ways to move the LOB data are to recreate the table (insert into ... select from...

With 30Gb data and ONLINE...