Yes, with Linked Servers. The requirement sounds a bit odd though. Why would you be connecting to another server to create a new stored procedure via T-SQL?

If they are only in the db_datareader and db_datawriter Roles why would they need to Design a table? Neither of those Roles give them permissions to do that.

Membership in the...

Lowell (1/18/2013)

---

Ells (1/18/2013)

---

you are correct, Mark: whether you place a DENY on the user, or on a group the user belongs to, the DENY will prevail and prevent access;(unless the...

opc.three (1/18/2013)

---

winmansoft (1/17/2013)

---

I have sql server express.So SSIS is not available for me.

Here is a sample of csv file i am trying to insert

QueryResult,QueryResult,500,2,46,A,abc,1,NULL,NULL,"date_atnd,time_atnd",,70,NULL,48,NULL

Here date_atnd,time_atnd has the comma in between....

I am...

Jayanth_Kurup (1/18/2013)

---

Am not sure if I am understanding the question right, there is autoincrement set to 1 MB for the database files. The files are located on indvigual disk drives....

winmansoft (1/17/2013)

---

I have sql server express.So SSIS is not available for me.

Here is a sample of csv file i am trying to insert

QueryResult,QueryResult,500,2,46,A,abc,1,NULL,NULL,"date_atnd,time_atnd",,70,NULL,48,NULL

Here date_atnd,time_atnd has the comma in between. So...

I only considered doing this once but never had to carry it out (we ended up migrating to new servers) so was curious towards the responses. I was watching this...

RonKyle (1/17/2013)

---

The Script Task brings with it some flexibility and ease of use that offer us some advantages over the other two techniques, yet has some potential drawbacks of its...

Thanks Mark and Timothy for the kind feedback. That's the kind of stuff that keeps me going!

Carrie Anne Moss :pinch:

Have you looked into SQL Server Compact Edition?

Can you switch to using SSIS?

If not then you may need to use a format file with BULK INSERT. You may be out of luck completely if the file is...

Job History is the only thing that comes to mind and that only holds up if all your SSIS packages are called by SQL Agent jobs.

Benki Chendu (1/17/2013)

---

I have 2 requirements:

1. Find the growth of user databases over a period of time, say for last 3 or 6 months.

I found this script but am not...