ashok.faridabad1984 (8/2/2011)

Hi Can you please let us know how to...

these two links are my favorite introductions to 2005 and up encryption; i found the article very easy to follow:

http://www.databasejournal.com/features/mssql/article.php/3714031/SQL-Server-2005-Encryption-types.htm

http://www.databasejournal.com/features/mssql/article.php/3483931/SQL-Server-2005-Security---Part-3-Encryption.htm

Laura in SQL 2000, there was no built in encryption, you had to use extended procedures.

When i was using SQL2000, i used the dba toolkit from SQL Server Central:

http://www.sqlservercentral.com/articles/Advanced+Querying/sql2000dbatoolkitpart2/2362/

you could...

i think you have to wait until something is executed first...it may have completed a second ago, but i don't think the dmv will return what is currently executing, just...

I'd think GSquared prototype is right as far as the tables go, but I'd be concerned with data population after it was created.

I'd think that based on the way I've...

this will show you any queries that are in the DMV cache that ever had a elapsed time of more than 15 seconds.

you could refine it from there, but this...

will the column support NULLS? if it can, you could update the data to be null where the column is that value.

it really depends on the table and the columns'...

where is that displaying?

zero (0) is SQL's starting date of 1900-01-01, so i suspect that either your query or your application is converting null to zero,a dn displaying that converted...

the C2 trace and the default DDL trace are not editable...but...

a trace is just a trace.

you can script out the C2 trace, the default trace, or any other trace on...

Yes Ninja absolutely GMail works; the only wierdness is the alternate non-"25" port,...

with SQL 2005 and above, tehre is a built in service you can use by calling msdb.dbo.sp_send_dbmail

you have to create a profile in SSMS (there's a simple wizard for...

i don't think you are supposed to include the packagename, are you?

for example, i've got a package that has a suite of 10 date functions and 6 string functions inside...

a quick fix would be to put the xcopy.exe in a folder that exists int he cmd lines PATH variable...then, since you do not need to specify the path fro...

justin.fernandes007 (7/29/2011)

I've been running a query to obtain sone data from a table "Tickets" which is as follows :

"SELECT *

FROM Tickets

WHERE CAST([Reported_Dtm] AS DATETIME )<='03/14/2011' AND CAST([Reported_Dtm] AS DATETIME...

how much of a change can you do? can you add your own proc, that does whatever the vendor proc did, but as a set based manipulation?

I know with...