Sure it can be different. The best example is sp_adduser that some apps use provide a front-end add user functionality. sp_adduser is marked as obsolete by Microsoft and it is...

 What is the role of the database? Is it OLTP (Online Transaction Processin) or OLAP (Decision Making, frequently queried database) ? If you do a lot of queries by this field by...

Jeff,

You may try to use sysprocesses table which has UID, nt_username and loginame fields if your users are using your application to connect to SQL Server. Your application may query sysprocesses which also...

Melvyn's reply looks correct.

I added a line with ColA=3 after the first try returned 2. After I added a row 'A', 3 to #TestUpdateB like he added 98...

Good News! I wish I could help.

Saturday downtime  is OK for me. I am doing  Boston Heart Walk on 18th, depending on the weather from 1 to 6 miles

Yelena

Hello,

Do you like scripts? There is a Scripting repository on Technet and there is a script for CPU usage:

http://www.microsoft.com/technet/community/scriptcenter/monitor/scrmon26.mspx

******************

Monitor Processor Use

Updated: February 17, 2003

Description

Uses cooked performance counters to monitor...

Hello,

I would stop the second instance, copy out all databases as in #1 and #2 by AJ. Then I would rebuild Master by rebuildm by SA24 recommendations. Then I would...

Scot,

I worked with ER/Studio database designer by Embarcadero. The problem working with those products that they are mostly non-Microsoft products oriented. What I mean, they just have an ability to...

Scot,

What is Rapid SQL v6 ? It is not SQL Server I assume and not MySQL. Please, describe in a couple of lines.

Yelena

Sa24,

Thanks for the syntax. I really like this thing.

Ed,

I was talking not about Windows Authentication versus SQL Authentication. Windows Authentication for users is good, but explicitly about making a...

Hello,

You may want to use Convert function. See Cast and Convert topic in Books Online.

CONVERT ( data_type [ ( length ) ] , expression [ , style ]...

Hi,

I agree with SQL Bill. Could you also post error messages here?

I have a comment: Why would anyone want to make a Windos login a dbo? I have a checklist...

Hello,

Please create a job with a Job Step that is of Type ActiveX script and Language VBscript. Then enter a script that uses FileSystemObject See the example of the script...

Chris,

I think "automatically" means "not manually"

SQL Server will or will not update automatically based as you mentioned on WITH VALUES clause that you have to add. Without adding WITH...

Hi all,

2 or more tables CAN be updated through the view in SQL Server 2000. It is a new feature in SQL Server 2000 and it is called Updatable Partitioned...