dukanif (5/17/2016)

---

but how can i connect to SQL Server if not use ODBC?

i used access yet but now i want use SQL Server such as main server to save data...

dallas13 (5/17/2016)

---

Thanks all but as I said application is not throwing any exception after I put GO. Also no syntax errors otherwise cant execute SP at all.Anyway thanks. I will...

I would execute the Create Stored Procedure Separately from the EXEC SP.

Make sure that the SP is created successfully first.

Why Server Core 2008 R2? That is old.

Before you know it you will be upgrading to a newer version of SQL Server.

Add a Send Mail Task to you package.

Check the permissions for the account that you are using for the linked server.

Make sure that it at least is a member of the database fixed server role db_datareader.

You may...

Can you ping the Server?

Can you remote into that Server, launch SQL Server Configuration Manager and check the configuration settings?

dukanif (5/14/2016)

---

Hello,

i installed MS SQL Server 2014 on windows server 2008 r2 , now i want connect to it from another computer in another internet , what is...

The problem was that the user was using SSMS 2008 against a 2012 Database.

Issue resolved.

sp_helptext works.

If you try generating a script table you get an error:

Index was outside the bounds of the array.

I need to check the version of SSMS that the user is...

Still not getting mail.

It is nearly 6:00 PM.

I need to get the error message from the user.

Mail Server is down.

Thanks.

Now I need to allow a group to be able to Script Table as ... on a Test Server.

It worked on Production for a Developer on Production by WITH THE...

You want to go into the SQL Server Agent Properties and click on history and increase the maximum job history log size.

Sean Lange (5/10/2016)

---

Welsh Corgi (5/10/2016)

---

When I execute sp_helptext on a Stored Procedure it returns that there is no text for object on a Stored Procedure.

How can I grant read permissions...