we have office365, so i just setup and tested a dbmail using it;

here's the scripted results, which will probably help you a lot:

i was in a rush, and named both...

in my shop, it would mean grabbing another backup of the "production" database and restoring it over the top of the Test Database that the developers and QA groups use...

i think it's the +90 INSIDE the datediff: '20130401' + 90 probably turns into either 20130491 or '2013040190', either of which are not valid datetimes.

maybe like this?

select *, '20'...

most likely permissions,

if you right click on that specific folder, and go to the security tab, you can see everyone who has permissions.

* Note that NT Authority\Network Service DOES NOT...

shew (5/30/2013)

---

[Background information]

I have a user who is convinced that his third party application is losing connection to SQL Server from a given app server (and the app will not...

kish DDL for a table would look more like this, having the compelte datatypes:

what you posted cannot be copied and pasted into SSMS, na dwouldn't help us build a...

shew (5/30/2013)

---

It looks as if SQLPSX will require a SMO install (which is not "policially suitable" for my situation), although SQLPSX itself appears to have a "manual installation" as an...

any chance there is a DDL server trigger or extended event doing it?

i've got examples of adding roles to a database automatically if they do not exist,whenever the a...

there's also several "portable" GUI equivilents of SSMS that would not require an installation;

the one that i keep on my PortableApps is LinqPad http://www.linqpad.net/?

not sure if that is an option...

if you are going to put the whole path for the executable, i'd suggest actually putting the full name of the executable and also the path to the package; you...

wow great job providing the setup;

my attempt is adding a rownumber ot partiton by two columns, and joining the results;

does this give you what you were after?

DECLARE @numbers TABLE (number...

here;s an example, with 0000 thru ZZZZ as the min/max values:

the first just generates example,s the second makes a calculated column based on the identity value of a table:

SELECT POWER(36,4)...

the other option, instead of EXECUTE AS, is to GRANT INSERT ON AuditDatabase.dbo.LogonHist to PUBLIC;

then every user would technically have rights to the table so the trigger can isnert into...

well if you want to do it via TSQL, look at my script contribution from a while ago;

a couple of procedure sp_GetDDL and sp_getDDLa which scripts any object:...

not sure what you mean;two different files would require two calls to bcp.

you can call If the startup account for SQL Server is a domain account, you could use a...