try this:

sqlcmd -S brdsqldev01 -d brframedevelopment -Q "SET NOCOUNT ON; SELECT name FROM sys.databases AS d WHERE CHARINDEX('Snapshot', name) > 0 AND create_date = (SELECT MAX(create_date) FROM sys.databases AS d...

Sorry, it's not possible. You have no control over the error message displayed at the client.

Huge congrats Gail!

If you're not returning columns from User_Activities, you can change the INNER JOIN to a WHERE EXISTS:

SELECT aBunchOfColumns

FROM User_Profile AS p

INNER JOIN aBunchOfTables

ON someCondition

WHERE EXISTS (

...

Memory is ridiculously cheap. Get more, you won't repent it.

However, if it's working reasonably well with 2005, it will probably work well with 2012 with the same amount of RAM.

You're absolutely correct about it.

Shrinking the log files generates massive file system fragmentation, which is hard to get rid of without downtime.

Shrinking is pointless: it will grow again, so let...

Have your sysadmins grant the permissions for you or let you RDP in the SQL Server box. Don't try to circumvent security with xp_cmdshell.

BTW, if the SQL Server service account...

SQLRNNR (7/6/2015)

---

spaghettidba (7/6/2015)

---

djj (7/6/2015)

---

Worked at a place that if you came in early that was okay but not seen as overtime. (not that you got payed for it but...

djj (7/6/2015)

---

Worked at a place that if you came in early that was okay but not seen as overtime. (not that you got payed for it but they wanted...

This wouldn't solve the issue: there's an access to a database which is not needed...

This should do:

SET DATEFORMAT DMY

CREATE TABLE #sampleData(

callref int NOT NULL PRIMARY KEY

, date_time datetime NOT NULL

, evb_recipient_email VARCHAR(29)

);

INSERT INTO #sampleData(callref,date_time,evb_recipient_email) VALUES (498987,'11/06/2015 08:22:04.000',NULL);

INSERT INTO #sampleData(callref,date_time,evb_recipient_email) VALUES...

You could use a server-side trace or an extended events session to capture the login failed events (profiler could also work if this is not a production instance). Have you...

It would help a lot if you could provide the following:

1) Table definition

2) Sample Data

3) Expected output

4) What you have tried so far

See here for help and tools to post...

You data appears to have a fixed structure and the code you're looking for seems to be always between chars 4 and 9. If it's guaranteed to be like that,...

Spam, reported