Ed Wagner (1/31/2013)

---

I really like batch files and I've used them for quite a few years. They can accomplish a lot and are quite a useful tool to have...

Forget Windows Batch, PowerShell was built for tasks like this.

Here is a one line command that does what you need. Add as many paths as you want and change the...

That looks like MySQL code. This is a website dedicated to Microsoft SQL Server. You may find more assistance on StackOverflow or the Oracle product website.

Agreed Best Practice is to try and keep everyone away from the instance during an upgrade but I think 'script upgrade mode' protects the instance now. All concerns surrounding taking...

How about a Web Service Task?

Bill Talada (1/31/2013)

---

If I purchase an application, I can use it any way I want to. I used to be an academic purist back when I first started in...

I am still not seeing a need to use xp_cmdshell or sqlcmd.

The stored procedure can execute the code dynamically using EXEC().

Not sure if XML Source has some limits, but you could try setting the output column to DT_NTEXT.

"Forwarding pointers" only if we're talking about a heaps, else a page split. Neither is good though. If you have a column that will initially be empty, even something wider...

yuvipoy (1/29/2013)

---

hi,

I am having a requirement like this

say if two table name is the input

i will take 2 tables and need to create a view

there may be common...

SELECT 1 AS a INTO #tmp;

GO

DROP TABLE tempdb..#tmp;

SELECT 1 AS a INTO #tmp

GO

DROP TABLE tempdb.dbo.#tmp

SELECT 1 AS a INTO #tmp

GO

SELECT * FROM tempdb..#tmp

-- look in messages tab

Modify your code so...

maida_rh (1/30/2013)

---

I will try your code and did this,which resolve my problem and SP is working fine :

ALTER PROCEDURE [dbo].[USP_Insert_UserSurveyUsingXML]

-- Add the parameters for the stored procedure here

--@XmlHandle int,

...

Admingod (1/30/2013)

---

I got below error message when I run backup logins using schedule job….When I run manually from the Job, instead of schedule it runs successfully.

error: "Cannot get the data...

redgate SQL Data Compare will most...

I have not found telnet to be all that reliable since some firewalls will block it. PortQry is what I use for things like this. It will allow you to...