homebrew i do something very similar as far as restoring an existing database.

i have a SQL job with the steps to handle the takeover and restore as separate steps; this...

bryan.holmstrom (7/27/2015)

---

Thank you for the quick reply but I need the actual tables not the system tables.

Database = 'xxxCRM'

Example table = accountbase (field = 'modifiedon' or even 'createdon' for each...

i would use the table and column metadata to generate the desired queries,a nd run them individually.

select

'SELECT TOP 10 * FROM '

+ quotename(object_name(object_id))

...

does filtering on the is_ms_shipped column work for you? it sems to remove things like MSreplication_options and spt_values and stuff for me.

select *

from sys.objects

where is_ms_shipped = 0

that is normal, expected behavior.

by design, you can grant a person access to a stored procedure which may affect objects the enduser does not have access to. .

using ownership chaining,The...

Adam McArdle (7/27/2015)

---

We have our packages password-protected because they have credentials in them, and Project...

i've put together this cursor in the past that iterates through all windows groups in SQL, and enumerates their members.

finally, i account names that were found for admin vs user...

quite a few issues there.

when you call sp_send_dbmail, you cannot append stuff togetierh for the paramters, you have to do that in advance, it has to be a single assignment,...

it might not be mentioned, as it's a transitory file extension:

[http://fileinfo.com/extension/wrk

---

File TypeSQL Server Log Shipping File

DeveloperMicrosoft

Popularity

2.0 (1 Vote)

CategoryDatabase Files

File Format Description

Database backup file created by SQL Server, a relational database...

what you are asking cannot be done in SQL.

SQL does not have image processing, or export to pdf, so you'll need to create an application that does the work...

this. if you don't have the service running, you must...

the convert function has an optional parameter for style/number of decimals? when the converted value is a decimal/float.

https://msdn.microsoft.com/en-us/library/ms187928.aspx

money and smallmoney Styles

When expression is money or smallmoney, style can be one...

you must have a trace or extended event in place,.

SQL does not capture who ran select statements /users info unless you create something to capture it.

theres some really good db comparison tools out there, like redgatecompare, or dbdiff , or a database schema comparison if you have the ultimate version of visual studio. they do...

the modern database mail uses a service broker, so it's fire and forget; you call sp_send_dbmail with the right parameters, and the proc returns immediately, and the service broker tries...