Lynn Pettis (1/21/2009)

---

GSquared (1/21/2009)

---

Yeah, but did you see the reply to that?

What's up with the grapes table that only has a priority column? What does that have to do...

You need to reference the SQL Server as Server\Instance,Port I believe.

Can you post the code?

I don't know of anyway to query this data. You would need to setup a server-side trace and let it run to see what tables have been accessed in...

Sure you can do this. You would put an expression in the color property (if you want the text to change colors) or the background color property for the...

Are you using Operators? You can define a pager address in the operator and set the hours you want the pager to be paged.

You can also check out the articles in Steve's Tame Those Strings series. Here's a search link for them:

http://www.sqlservercentral.com/search/?cx=000517265726492607871%3Agqdiynsp-y0&cof=FORID%3A9&q=tame+those+strings&sa=Go#1193

With SQL Server 2005 and above there are password policies available fro SQL logins and one of the options is that the user must change password on next login and...

Okay, the first thing is you are not changing the query timeout in the connection string and believe by default that is 30 seconds. Of course most processed on...

You would use the Execute SQL Task in SSIS. You can either write the query there or create a stored procedure that you call from the Execute SQL Task...

Yes, WHERE EXISTS/NOT EXISTS can perform slightly better. Until recently I was more comfortable reading the LEFT JOIN syntax, and in this case both will work, one, IMO, the...

I'd start by including it with my system database backups with the addition of some log backups. Then I'd monitor log growth and adjust my log backups as needed.

Any chance we might see some code?

I'm assuming you are using SQL Reporting Services. If that is correct then, yes, you can use the selection from query 1 to populate the parameter for query 2....

I agree with Jeff. The only time you may want to disable a trigger is when you are doing a mass load/update/delete that does not have to be covered...