I don't know if this would work, but it's a thought:

SELECT e.empid,

e.name,

COUNT(t.ID) as 'tcount'

FROM tasks t

RIGHT JOIN employee e ON c.empid = t.empid Or t.resolution Is...

I don't think they had object browser in SQL 7. It's been a while, so I could be wrong, but i think it was new in SQL 2000. If I'm...

Nope, no nested tables in SQL Server.

Sorry, I forgot that I don't need to escape the underscore with square brackets because it is already inside of square brackets.

Declare @val varchar(128)

Set @val = 'i&&35iC4io'

Select PatIndex('%[^0-9a-z_]%', @val)

Read my article: Practical Uses of PatIndex: http://www.sqlservercentral.com/columnists/rdavis/practicalusesofpatindex.asp

You could use the sample code there with some slight modifications to get what you need. Use the NOT operator ( ^...

This works a lot smoother if you do it all in one fell swoop. Like so:

Use MyDatabase

Alter Database MyDatabase Set Singel_User With Rollback Immediate

Restore Database MyDatabase ......... blah blah blah

Alter...

Roger Staubach was THE MAN!!! I remember growing up in the Dallas area and hearing people refer to Texas Stadium (where the Cowboys play) as the House that Meredith Built...

Of course, I don't think the author's intention was to claim that Context_Info was the solution to all of our security concerns. I think he merely chose that as an...

Which is why I copy.

>> Still don't follow.  You are still using the same "packet" thingys when you copy the file.  So there is an equal chance for a dropped packet to cause corruption.

Yes,...

Yes, if space dictates backing up to a remote server, then certainly do so.

If the remote server is down, you can't make any backups at all without manual intervention. Using...

IO isn't the issue. The issue is the network. If there are dropped packets or a network glitch of some sort during the backup process, the backup either fails or...

I believe a SAN COW would be a database that fills the whole SAN by itself.

I should also add that I can disable or drop the trigger as well.

Here's a script I wrote after a service pack installation deleted all of our default file locations. It is for SQL 2005, so it may need to be modified to...