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 5 years, 10 months ago by Lowell.
• This reply was modified 5 years, 10 months 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.

one of the core caveats of the development life cycle is that  the code is tested in dev, and is promoted UNCHANGED to the next layer for acceptance and testing.

if...

you can check teh procedure cache.

if you run this, you might see the same procedure multiple times, because each has a specific execution plan due to different parameters:

            
October 21, 2019 at 1:13 pm
            
#3690562

            
            
                                                
        

does the machine in question have more than one instance installed? could you have updated just one of the multiple instances on that machine to SP4 instead of all of...

generating the schema scripts for tables/views/procs is easy in SSMS, but don't script the data. 60 gig of data is unmanageable as flat files, you want to use The import...

it is not possible to restore a SQL database from a higher version to a lower version.

you can only restore from lower to higher versions.

you will have to use something...

I think you want to convert the date to varchar, and if the results is NULL, use the string NULL

ISNULL(convert(varchar(20),@Date,GETDATE()),110),'NULL')