SO you are saying if the table itself is modified is what you want to know? There are many threads in the forum on this and the first thing some...

First go here and pick up the script to find a string in a database object. http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=184 you will need to install to master db.

Then try this (note: wrote to...

Or

order by

case

when nullif(field3,'') is null then 1

else 0

end

,field3

To combine shrink code needs, the only problem I see with epols idea is zzz is last yes but zzza would...

You can but this is considered a bad practice since you want to control this access and if you give everyone the SA password when any one person leaves or...

There is no sp to change NT Service passwords. SQL Server Services and SQL Server Agent are running as NT services not inside SQL. What are you looking for?

"Don't roll...

Check out http://support.microsoft.com/default.aspx?scid=kb;en-us;Q313980& should answer.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

May or may not have the effect of making things better. If you made index changes then I believe it would but without all you can do is try. System...

Can you post the full error message, I don't use Application roles and have not heard anything on this, but with the message I can search several locations to see...

Any specific error as I have not seen any issue with access after an SP install except TCPIP connectivity. Also check SQL Error logs and EventViewer logs to see if...

Is it still growing, and what is the process doing? I have not seen anything on my 2000 server with tempdb that is different from the behavior on a 7...

My trriger does not affect me in this way. Are you calling @@ROWCOUNT immediately after the INSERT/UPDATE/DELETE statement? Here is my Example

CREATE TABLE [A] (

[ONE] [int] NOT NULL ,

[TWO] [varchar]...

Did it clear or you find another way around? If not then this may work, stop SQL server, rename the files for the DB, restart SQL. Now when you view...

Bulk transaction or unlogged events can have this effect. You don't have anything issueing trucate table, bulk insert, or using bcp do you? If so then you will have to...

What is the bat file doing and how does it relate to the DTS package? Have you got flow logic in place to make sure step in package are excuted...

VB is one of the simplest ways to make the change. However you can even do a lot in Access but the key is to use ADO to connect to...