Well, my database was much smaller.

How long does it take to run de script in SSMS?

Multiple scripts - it was easier for me, but you may have other idea -...

Do you create each object separately? I used to have scripts for database, tables, procedures and other objects separately. Running them never took more than 30 seconds.

Piotr

Yes, foreign key itself doesn't create an index. This is quite common misconception. You have to create an index on foreign key columns to speedup queries.

Piotr

Check your settings in

Tools/Options->Query Results/Sql Server

Maybe you have 1000 set there?

HTH

Piotr

Try to use this:

convert(datetime, convert(varchar, createddate, 103), 103)

The problem is in the fact that your conversion is using default connection language for outer conversion and if this language happens to...

The problem is not with single quotes, but with the way you insert data intto database. This issue arises when concatenation of queries is used instead of parameters. Moreover, your...

What is the format of date returned from database if you use your account? How do you convert it to requested format?

Piotr

Look also at default language for logins these users use.

Piotr

Have you tried to set up German collation on columns you are interested in?

Piotr

The full text search work only on data stored in database, not outside of it. It won't search for anything in external files.

Piotr

Maybe it's worth to mention that sp_depends CAN work properly if there are two conditions met.

1. All dependent objects are created before a procedure is created

2. Dependent objects are not...

You have to create connection to that CMS system using linked server functionality. Read about linked servers in BOL.

Piotr

Hmmm from my experience.. not really. SSIS is a cow - huge, memory hogging beast that is hard to debug and not very nice in managing from code. Also there...

Perhaps I would add another layer between programmer and database, or at least helper class that would take this one million of objects, convert them to XML and called a...

Hi,

1. No, databases do not have to reside in this folder

2. There is a Surface Area Configuration tool where you can set the connectivity and protocols.

3.MDF file is just a...