Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
RBTrout
Starting Member
6 Posts |
 Posted - 2014-02-04 : 13:47:31
|
| Server 2003 running SQL2005. I know, I know, I'm way behind. I'll be upgrading this year.I've got a script that I usually run through the Management Studio. I'd like to run it through a script. Using SQLCMD with parameters, I'm able to fire off the script, but I get a login error. Top of the script is:use <dababase>create table <tablename>When I get to the create table, the sqlcmd returns'create table permission denied'.I'm sure it has to do with logging into the DB as an administrator, but I'm not sure how to set that up in the script. |
|
|
RBTrout
Starting Member
6 Posts |
Posted - 2014-02-04 : 14:16:30
|
| Duh, sa login. I've got it. Sorry for wasting your time. |
 |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2014-02-04 : 17:46:37
|
| We've all been there... (Some of us have taken up permanent residency there...)===============================================================================There are two kinds of light -- the glow that illuminates, and the glare that obscures. -James Thurber (1894-1961) |
|
|
|
|
|
|
Database Login through a script