Showing posts with label means. Show all posts
Showing posts with label means. Show all posts

Friday, March 9, 2012

Dose sp_helptext loss something?

I am using sp_helptext to generate script of stored procedure. However someone said sp_helptext loss something if stored procedure is big. That means the script is not completed. Is it true?
Thanks
ZYTJust curious, why not use Enterprise Manager to right-click on the stored procedure, then go to All Tasks -> Generate SQL Script...?

Then you can punch the "preview" button and then the "copy" button to get the script onto your clipboard.|||Thanks for reply.

Because I need to create script from stored procedure.|||If you need to create a script from the stored procedure, why not use Enterprise Manager to right-click on the stored procedure, then go to All Tasks -> Generate SQL Script...?

Then you can punch the "preview" button and then the "copy" button to get the script onto your clipboard.|||sp_helptext only returns the first 4000 chars as i recall.|||Good Job, Jez...probably more constructive than a third post from me ;)|||check out this app I wrote if you want to generate scripts in an automated way:

http://www.codeplex.com/scriptdb

Sunday, February 19, 2012

Dollar sign behind user name

What does the $ (dollar sign) means behind the SQL Server login?
I had a SQL Server login something like this "DomainName\User$".
Peter ChanThis is generally a computer account. If a service runs under Local System
or Network Service on a remote computer it can be allowed access to SQL
across the network via it's computer account (which is the credential it
passes over the network)
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
http://sqlblogcasts.com/blogs/sqldbatips
"wodoy.peter" <wodoy.peter@.gmail.com> wrote in message
news:1175854131.654355.132230@.y80g2000hsf.googlegroups.com...
> What does the $ (dollar sign) means behind the SQL Server login?
> I had a SQL Server login something like this "DomainName\User$".
>
> Peter Chan
>

Dollar sign behind user name

What does the $ (dollar sign) means behind the SQL Server login?
I had a SQL Server login something like this "DomainName\User$".
Peter ChanThis is generally a computer account. If a service runs under Local System
or Network Service on a remote computer it can be allowed access to SQL
across the network via it's computer account (which is the credential it
passes over the network)
--
HTH,
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
http://sqlblogcasts.com/blogs/sqldbatips
"wodoy.peter" <wodoy.peter@.gmail.com> wrote in message
news:1175854131.654355.132230@.y80g2000hsf.googlegroups.com...
> What does the $ (dollar sign) means behind the SQL Server login?
> I had a SQL Server login something like this "DomainName\User$".
>
> Peter Chan
>