SQL Server cuts the rest of the bytes.

Try this:

DECLARE @t TABLE (txt VARCHAR(12), ntxt NVARCHAR(12))

INSERT INTO @t VALUES (N'????? ??????', N'????? ??????')

SELECT txt, DATALENGTH(txt) txt_bytes, ntxt, DATALENGTH(ntxt) ntxt_bytes

...

If you don't use an IDENTITY column you can import the date into a temp table and use the following statement to add an incremental id:

IF (OBJECT_ID('tempdb..#test') IS NOT NULL)

...

The "server" which calculates the report data should be the SQL Server 😉

Let me try to explain what we are talking/writing about with an example:

Let's assume:

* Your database contains consignees,...

Try to change your ROWTERMINATOR to:

-- Replace the @ with a backslash. The forum cuts them if I use it...

ROWTERMINATOR = '|@r@n'

Greets

Flo

You should use SHRINKDATABASE instead of SHRINKDB.

Side effects:

* Because the database usually becomes shrinked to minimum size it will become slow for the next file extend within the next some...

Quiet strange... This reports should be available on each database node (not on server or tables)...

If you can't find it execute this:

execute sp_spaceused

This will also show you the database size...

Which database version and edition are you using?

If you are not sure go to a SQL window and execute:

PRINT @@VERSION

Greets

Flo

CHAR data type is not needed in most cases. (I don't even know any reason - if anybody knows please tell me).

The difference between 20gb and 500mb is very huge....

Hello

No, that's not possible if your server is part of the domain. You can remove the domain admin from local server permissions but he is always able to back the...

In this case its simple. Use a FULL join and exclude the matches by WHERE id columns are NULL:

DECLARE @v1 TABLE (id INT, txt VARCHAR(100))

DECLARE @v2 TABLE (id INT, txt...

Do these views return any unique id?

Greets

Flo

I'm not sure if it's the...

If you only need the profiler do not install the server components and (if possible) do not install the BOL. I'm currently not able to try an SQL Server installation...

Hello Steve

First sorry for my wrong answer! I really didn't know...

To your storage problem. What about compression? Almost every client programming language supports compression methods (like GZIP). So you can...

Wait for the service pack update :D.

What's the problem with this duration? Maybe de-select some of the components to be installed. If you only need a OLTP database server do...