Please provide a sample of how the expected output should look.

VIEW SERVER STATE permission for server-level and VIEW DATABASE STATE permissions

Custom reports run by using the permissions of the current user. To prevent a malicious user from changing the queries run by the report, permissions on the file system folder...

I license per processor used by SQL Server (on the server).

Ray K (2/4/2010)

---

As Maxwell Smart used to say,...

If you want the indexes and such to follow, you should script it out and execute that script on the destination. Another option is to use a tool Such...

The Dixie Flatline (2/4/2010)

---

One of the differences between table variables and temp tables is that no statistics are kept on table variables, while statistics are kept on temp tables. ...

And with the rollback, you must wait it out.

Standard.

Unless you need additional features and functions, then I would go Enterprise. However, Enterprise edition is very expensive.

carloparcon (2/4/2010)

---

server 2008 standard edition 64 bit, sql server standard 64bit, kaspersky enterprise for windows server, thats it

im quite new in sql environment,

what do you mean sp_oa?clr? im sorry, could...

You're welcome.

current session.

From MSDN

This setting affects the interpretation of character strings as they are converted to date values for storage in the database. It does not affect the display of date...

if you set a default on the field to accept a specific format - it should convert it for you.

Are you capturing more information than that? If you know...

That is a good suggestion.

My question is why create a primary key like this? Do you ever need to increment the alpha part of the PK?

Have you considered a...

if you import the date into a datetime field and then use the following:

SELECT convert(varchar,convert(datetime, '2/4/2010'),103)

You should be able to accomplish what you need.