Sorry,unless you have some auditing in place, before it happened, it is not possible.

you can get basically the last executed information for current connections from the DMV's, or using sp_whoisactive,...

i think the right thing to do is is go straight to sys.dm_db_index_usage_stats, which keeps track of how many times an index was used for seeks/scans/ lookup/updates.

the data is only...

i poked around the metadata with this query, and looked at views that seemed interesting:

SELECT * FROM sys.all_objects WHERE type='V' AND name LIKE '%avail%' OR name LIKE...

16 Gig is fine. for three servers, i would say you need 3-4 gig per server, i've done 1 core / 2 gig per server, but they are painfully slow,...

I know if you install IIS or some other web server, you can redirect the default name of the server to the right folder;

so if someone goes to http://MyserverName, the...

for me, that OR statement is something i think i would switch to two separate queries, for each of the two sets.

ON a.ra_number = b.ra_number

and (a.ei = b.ei or...

db_datareader gives permissions to all SELECT-able objects, which would include tables and views.

I think you wanted just specific views, so you have to turn to dynamic sql:

offhand, it would look...

so there's two things here you have to check.

the D:\ drive here must be on the SQL server.

@file_attachment = 'D:\Test\results.txt',

if the drive is not on the server,...

• This reply was modified 6 years ago by Lowell.
• This reply was modified 6 years ago by Lowell.

on most of my servers, the log files are on a completely different drive; it is more common on bigger installations to seperate the data to multiple drives.

so the mdf...

Mike Vessey has the answer there. USERS don't have passwords (except in contained databases, there's always an edge case)

so you have to change the LOGIN that the USER in the...

I have had some scripts like that error int he middle do that, and it was because my \\unc path was out of space. i could do the first few...

you'll need to modify this query with your names:

EXEC sp_dropserver 'OldServerName' 
EXEC sp_addserver 'NewServerName', 'local'

after that, there will be a difference in @@servername until you can stop...

we store files in our databases and varbinary(max)

you would be adding an extra step to convert varbinary to base64/varchar(max). then if you need the file, you have to double convert...

dang i missed that part.

https://social.msdn.microsoft.com/Forums/SECURITY/en-US/dfa95b28-e2aa-465d-b34a-b230b3d0b624/ssis-azure-blob-source-limitation?forum=sqlintegrationservices

that literally says bring it into someplace where you can use a flat file connection manager, since it is not supported yet.

sorry:

Azure Blob Source does not...

in your flatfile connection manager, change the text qualifier to a double quote. it will remove the dbl quotes when it builds that path to the destination for clean data.