Showing posts with label image. Show all posts
Showing posts with label image. Show all posts

Tuesday, March 20, 2012

changes to bcp arguments in sql server 2005

Hello All
Seems the arguments have changed for bcp in sql server 2005(CTP). -T use to
be for the trusted connection now it is text or image size. There are new
arguments like -V[security_option] and -Z[security_mechanism]. Does any one
know how to use these new parameters and if you can still do trusted
connections for logining in with BCPShelly,
Please see:
http://www.aspfaq.com/sql2005/show.asp?id=1
For your question however, it looks as -T is still to specify a Trusted
Connection.
Please see:
http://msdn2.microsoft.com/en-us/library/ms162802
HTH
Jerry
"shelly" <shelly@.discussions.microsoft.com> wrote in message
news:9161D896-CFC7-4F5D-A16F-E5B109227AA4@.microsoft.com...
> Hello All
> Seems the arguments have changed for bcp in sql server 2005(CTP). -T use
> to
> be for the trusted connection now it is text or image size. There are new
> arguments like -V[security_option] and -Z[security_mechanism]. Does any
> one
> know how to use these new parameters and if you can still do trusted
> connections for logining in with BCPsql

Sunday, March 11, 2012

Change what machine name (local) points to

I imaged my machine and moved that image to a new machine with a different
machine name. Now I try to create a database in Local and receive the
following error:
"Could not obtain exclusive lock on database 'MODEL'. Retry operation
later. CREATE Database failed. Some file names could not be created. Check
previous errors."
I'm useing SQL Server 2000 on an XP machine.
Has anyone seen a problem like this before?
Nevermind, had to re-register the local server then restart the service. I
missed the service part...
It's fixed.
"nate axtell" <naxtell at progeny dot net> wrote in message
news:Ob6COEl$EHA.2700@.TK2MSFTNGP14.phx.gbl...
>I imaged my machine and moved that image to a new machine with a different
>machine name. Now I try to create a database in Local and receive the
>following error:
> "Could not obtain exclusive lock on database 'MODEL'. Retry operation
> later. CREATE Database failed. Some file names could not be created.
> Check previous errors."
> I'm useing SQL Server 2000 on an XP machine.
> Has anyone seen a problem like this before?
>

Change what machine name (local) points to

I imaged my machine and moved that image to a new machine with a different
machine name. Now I try to create a database in Local and receive the
following error:
"Could not obtain exclusive lock on database 'MODEL'. Retry operation
later. CREATE Database failed. Some file names could not be created. Check
previous errors."
I'm useing SQL Server 2000 on an XP machine.
Has anyone seen a problem like this before?Nevermind, had to re-register the local server then restart the service. I
missed the service part...
It's fixed.
"nate axtell" <naxtell at progeny dot net> wrote in message
news:Ob6COEl$EHA.2700@.TK2MSFTNGP14.phx.gbl...
>I imaged my machine and moved that image to a new machine with a different
>machine name. Now I try to create a database in Local and receive the
>following error:
> "Could not obtain exclusive lock on database 'MODEL'. Retry operation
> later. CREATE Database failed. Some file names could not be created.
> Check previous errors."
> I'm useing SQL Server 2000 on an XP machine.
> Has anyone seen a problem like this before?
>

Change what machine name (local) points to

I imaged my machine and moved that image to a new machine with a different
machine name. Now I try to create a database in Local and receive the
following error:
"Could not obtain exclusive lock on database 'MODEL'. Retry operation
later. CREATE Database failed. Some file names could not be created. Check
previous errors."
I'm useing SQL Server 2000 on an XP machine.
Has anyone seen a problem like this before?Nevermind, had to re-register the local server then restart the service. I
missed the service part...
It's fixed.
"nate axtell" <naxtell at progeny dot net> wrote in message
news:Ob6COEl$EHA.2700@.TK2MSFTNGP14.phx.gbl...
>I imaged my machine and moved that image to a new machine with a different
>machine name. Now I try to create a database in Local and receive the
>following error:
> "Could not obtain exclusive lock on database 'MODEL'. Retry operation
> later. CREATE Database failed. Some file names could not be created.
> Check previous errors."
> I'm useing SQL Server 2000 on an XP machine.
> Has anyone seen a problem like this before?
>