You should find the info you're looking for here:

http://msdn.microsoft.com/en-us/library/ms175475.aspx

Hope this helps

Gianluca

if you're lucky enough, you should find your file somewhere in

C:\Users\[your_user_name]\Documents\SQL Server Management Studio\Backup Files\Solution1

Good luck!

I guess the whole problem is the ISNUMERIC function. It returns 1 for \r and :

SELECT ISNUMERIC(char(10)), ISNUMERIC(char(13))

See this article by Jeff Moden for alternatives:

http://www.sqlservercentral.com/articles/IsNumeric/71512/

Hope this helps

Gianluca

Other possible options:

1) Snapshot replication

2) Transactional replication

In both cases you could set up row and column filters and replicate just what you really need.

You're welcome.

Glad I could help.

+1

Performance is my major concern.

Also, usability (is...

You're trying to make your PIVOT dynamic, right?

Then just use dynamic SQL. In your example, the variable that determines the number and content of columns is the year: query distinct...

I knew you wouldn't have liked my reply...

Don't mistreat it that way: it was almost...

Check:

1. default database for this login

2. logon triggers

What does the logon error say exactly?

SQL Kiwi (1/10/2012)

Please do. It can do everything you have asked easily, you just need to invest a little time trying it. ...

Would be redundant IMHO.

Does it work with IPAll blanked? Then, leave it blank.

I'm using wordpress.com and there you just need to surround your code with

[sourcecode language=sql]

SELECT SomeColumn FROM SomeTable

[/sourcecode]

and everything displays just fine, with copy,print,view source and help buttons.

You can see...

Don't enclose the user name in square brackets:

IF NOT EXISTS(SELECT principal_id FROM sys.database_principals WHERE name = 'mylogin')

BEGIN

CREATE USER [mylogin] FOR LOGIN [mylogin]

END

Ninja's_RGR'us (1/10/2012)

how many time do you want me to top this story with...