You can run traces, but I don't think that login and logout events will give you the correct info. You probably have to run traces for TSQL-SQLBatchCompleted event or SP-Completed...

I would call your subscription support or reseller.

Hi,

I found a workaround. I create maintenance plans to backup all databases or all user databases (whatever is appropriate). Then if a new database is added, it would be backed...

Hi,

this thing works for me for Windows 2003 servers, but does not work for Windows 2000 servers. I can run this query towards remote computers if I connect Object Explorer...

Is there a need to create an index on the menu table? It should not be a lot of records in this table?

Notification Services is a new feature of SQL Server 2005. There is no Notification Services in SQL 2000. Yes, this is a service.

Michelle,

Unless you are changing data types (say, varchar to nvarchar) the size of data will be similar. Also Oracle as I was told takes more space for system tables. I...

Hi Tim,

Nice to know!

What is well, not obvious (to say the least) where you find your aliases:

1. On Windows 32 bit you will find your aliases under Client Network Utility...

Maybe I would use MS ACCESS for that. I was participating in the projects where we used MS ACCESS to copy from different sources into SQL Server with processing. The...

I had to trick it.

In SQL Server 2000 I first used Import/Export wizard to copy data from MySQL table to SQL Server table. I changed data in SQL Server, so...

Your NEW laptop may not have domain things set up, like DNS server in the TCP/IP properties, domain suffixes etc so name resolution does not work. Did you try to...

If you enter each of 1024, 1054 and 1073742848 in the Calculator, set View->Scientific and click Bin button, then you will see that 1024 bit correspond to 1 (one) in...

There are other ways to stop user connections to SQL Server except for denying logins. Since the restore time will not be long as you sais the DB is not...

Al,

I don't use MySQL for production, I am only testing for one of the future projects. I can test with SQL 2000, will let you know

I have no problems updating MySQL database using MS ACCESS Linked Tables when I use MySQL Login that have rights to delete from or to write to the database.