"We have two identical databases to serve testing and development purposes. I thought it's better to differentiate between those two not only by the database name, but also by the...

You could use an activeX script to get the file name and then set a global variable. You can parse the file name into the component parts and then...

Found something on the SQL Server Magazine site:

For NS2.0 (SQL 2000): If Notification Services is installed on Windows, you will find this registry key:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\NotificationServices

...

You are not off base for the long run, but before going thru the effort of writing the tools for the methodology, there are some simple tools available from Microsoft...

Here is a shortcut to BOL from SQL Query Analyzer: highlight a term, such as "create trigger" and then press SHIFT-F1 - BOL will automatically open.

Good Luck

"Then give an example that illustrates a problem that may occur if the property is not supported"

Using the Northwind example database, consider the following three SQL fragments:

1. Insert into...

"Guest" is a special user and actually cannot be removed but you can revoke the database access. Once access is revoked, sp_helpuser and EM, will no longer show the user.

From...

Ok - the problem is you do not understand how inserts, updates and deletes are actually implemented by SQL Server. Most of this is copied from BooksOnLine:

Two special tables...

Regarding the disk drives:

1. Use the smallest and fastest drive that you can purchase (36Gb at 15K RPM ? )

2. Use RAID-1 not RAID-5

3. Use a seperate disk for each...

IF the users have db_owner role, then no, they have complete control over the database.

Check if ddl_admin role is sufficient.

sp_execresultset is part of SQL Server 2000 but is an undocumented system procedure, so you will not find it in Books OnLine.

If your server has a case sensitive collation, then...

I ran another test using the sp_dso_ExecProcessMatchImportDTS stored procedure but with my DTS package and passing the value of the global variable worked fine. This leads me to believe...

Please post create table and insert statements not lists of data values.

insert into mainItems

(MainItemNumber ,MainDescription, MainColor)

select 11222, '11222', 'Purple' union all

select 11233, '11233', 'Purple' union all

select 11244, '11244', 'Purple'

insert...

I just ran a test an you do NOT need a Dynamic Properties Task unless a global variable is used to set a connection property.

The table "GlobalVariableSave" is only for...

"I'm a novice DBA and I'm trying to create stored procedure to truncate log for all databases (except for system databases) in my sql server."

This is a very bad idea....