No, neither was using a view.  Due to other problems I formatted this system and tried again.  I still received the error so I called Microsoft PSS.  Worth the money! ...

What are you exporting from and to? 

Importing from Excel is a lesson in patience.  Might check to see if you imported the Print Area of the worksheet and that the two new records you imported are...

Every 5 minutes, I issue sp_who2 from a SQL Agent Job. I save the data to a table and then can query the table over time to see what databases...

I like the search feature on the new forums.  I'm finding answers now.  Thank you for that!

Michelle

Christy -

I have lived through the nightmare of having small databases local and then needing to combine them.  If at all possible, make changes so your users can insert to...

Feifei  -

Are you using Enterprise Manager on the server to see all the records and then comparing that speed to using Query Analyzer on a local machine and seeing...

I'm finding the same thing.  I am using IE version 6.0.2800.1106.

If I hit the refresh button (F5) it reloads the page.  Usually the rthird reload loads the page completely (I...

Could you have another table and the user inserts into it the changes he/she wants to make.  Into this table you would include the unqkey (or some record identifier) from...

I'm not quite sure what you are asking.

When you open a table in Enterprise Manager to see all the data, it creates a 'firehose cursor' to pull it in. Using...

Hi Christy -

You could install the MSDE version of SQL Server on each client machine and then have a local SQL Database that could communicate with the server copy.

Do you...

Cliffb -

Breathe in...Breathe Out (sorry, that is just what others tell me when I start ranting)

I liked the question (except for the mispelling).  I know when I should use the...

15CriticalBackupRestoreAlerts.sql I'm not finding a way to access this script.

Once these alerts are generated, how do you get notified? Do the DBAs read the error logs or get...

Yes. If you add a file to a filegroup, then SQL starts filling both files.

I believe adding a second log file works the same way, SQL starts...

I like knowing how you guys started out. I have enjoyed and learned a lot in my time here at sqlservercentral. It was great to see you at...