Please check to make sure that the SQL Server service account has at least read permissions on the network share?

You could copy the backup file to your local machine then perform a restore.

And if that's not possible then check to make sure the SQL Server service account has access...

How about:

Set @bigIntCardField1 = @Card * -1

SQL server does an implicit conversion from int to bigint so no need to cast @Card

My goal for 2013 is to get the following certifications:

MCTS: (432) Microsoft SQL Server 2008, Implementation and Maintenance

MCTS: (448) Microsoft SQL Server 2008, Business Intelligence Development and Maintenance

Wish me luck!...

You're right.. I take that back :blush:

Then that's normal application behaviour I'm afraid.

If you want SQL Server to retain your comments within the stored procedure then you need to include the comments within the body...

You may want to check this link: http://en.wikipedia.org/wiki/Jaro%E2%80%93Winkler_distance

There are various implementations of this algorithm in T-SQL and CLR but should be easy to Google for a readymade function.

I've not tested...

When I script out a stored procedure in SSMS, the SET QUOTED_IDENTIFIER ON is placed above the Stored procedure declaration. So I'm wondering, are you sure you're including the comments...

Minaz Amin (12/14/2012)

---

Thanks.

I will check the link.

Also Iam trying to using paramter in the datasource but it failed with the following error. Almost broken :w00t: but every run...

I assume that you can't use linked servers as you mentioned storing SQL logins in a table. Is this the case or are you able to setup linked servers to...

Are you able to setup linked servers?

There are two parts to your process.

1) Information gathering

2) Report generation.

For the information gathering you could implement this in

a) Scheduled T-SQL script if you're able to use linked servers.

b)...

Credits go to dwain to be fair lol I used his method it's better than my original solution.

Good luck!

montse 22199 (12/12/2012)

---

Thanks a lot!! this one is working fine!! Now I have another question :w00t:

I already have a view (ED) with the following syntax:

SELECT ContactId,Effective_Date,Semester,'EffectiveGraduationDate'= DATEADD(year, 4, EGD)...

You may have to create an inbound firewall rule but check the above first.