There can be any number of databases in sqlserver.

You have 4 system databases:

-master

-msdb

-model

-tempdb

(you can have some more in a distribution context)

All other databases are user databases.

So you need to...

This is typical abuse...

Dugi (9/15/2008)

---

Interesting ... but little bit confused couz for the moment I haven't any idea how to use it in my column ...my column is not datetime it is just...

http://www.sqlservercentral.com/articles/SQL+Puzzles/findinggapsinasequentialnumbersequence/2336/

http://www.sqlservercentral.com/articles/Datetime+Manipulation/61822/

I would say their windows firewall isn't opened to use the sqlserver ports.

it's better you don't.

Leave formatting to the client application !

p.s. only use Nvarchar if strictly needed !

well.... use the correct datatype !

In this case datetime.

This way one cannot enter invalid data in the first place.

Now you're stuck with character columns containing data that is invalid...

Here are some urls I've used just to investigate some scenarios:

http://blogs.msdn.com/lcris/archive/2006/10/19/sql-server-2005-an-example-for-how-to-use-counter-signatures.aspx

http://blogs.msdn.com/lcris/archive/2005/12/16/504692.aspx

http://www.lakesidesql.com/articles/?p=15

And I think even BOL has some nice examples.

First step to do before actually launching any upgrade/hotfix = backup ALL databases !

This way you are safe to at least a reinstall up to your current software level.

Most...

I've seen some demo stuff using the approach that every doctor had his own ssl certificate used for encryption of e.g. diagnose varchar columns, so only the one being granted...

This is the classic behaviour I wanted to point to in my warnings

http://www.sqlservercentral.com/Forums/Topic567766-8-1.aspx

- Did you switch your db to db-level 90 (sql2005) or did you leave it on 80 after the restore ?

- You need to rebuild all indexes.

- you need to...

How much do you trust your dba ?

Don't you have deonthology rules ?

Implement SOx or HIPAA guidelines, so that every (high privilege ) access needs to be justified by a...

Oh yes, functions can be like troyan horses,....

they may serve you very well, even for a long time, until your system reaches the condition for them to burst open...

SQL will try to balance the content of files in the same filegroup.

If you want to take that under your control, you should create your own filegroups and move...