my Google-Fu is strong.

you can optionally delete to the recycle bin with powershell:

http://stackoverflow.com/questions/502002/how-do-i-move-a-file-to-the-recycle-bin-using-powershell

rebuilding the index requires a lot of space...I've heard a rule of thumb as 1.5x the size of the table.

maybe you rebuilt the indexzes? large overnight ETL?

from MS:

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

glad I could help a little bit!

here you go; this is the best way to provide sample data in the future; anyone who follows the thread...

also, it depends on the file format;

if the original source text file was created in unix, you might need to use \r ( vbCr = CHAR(13)/ Return/Carriage...

sqlfriends (2/22/2012)

---

But we have 3 peoples may take turn to run the job.

And I don't want give them rights to view or run other jobs because this is a production...

these two extended procs examples might help.

one tells you who belongs to a group, the other can tell you all the grouls i belong to:

EXEC master..xp_logininfo

@acctname =...

pretty loose on the details.

do you have to copy the backup(s) from somewhere to the UAT server now?

do you have the current backup(s) scripted out already so you can just...

unless you already have created a trace which is capturing that information, it's not available anywhere. SQL server does not keep track of successful logins unless you enabled it or...

Different application hitting the server, or the identical application and same traffic?

It's been mentioned at least half a dozen times that SQL using all the memory is perfectly normal, but...

AWE settings have no affect on 64 bit isntallations.

by default, SQL will consume 100% of the memory, or up to 100% of the maximum you set.

What can be a little...

link from above updated: the link had an extra

character in it after the forum rendered...

what events are you using?

my traces usually have both SQL:BatchCompleted and RPC:Completed

RPC:Completed will return code when a proc is executed, whether in TSQL or when a command object has...

and another way, via an extended stored proc:

EXEC master..xp_logininfo

@acctname = 'mydomain\lowell',

@option = 'all' -- Show all paths a user gets his auth from

go

EXEC master..xp_logininfo

...

from your query so far, i couldn't infer any datetime columns exist that you could pull the year out of.

there is a YEAR function that will get the year of...