If you don't use the alter table.. add colum ... methode you also need to take care of foreign keys (from or towards your table) !!

if you perform it the EM-way (rename / create new / insert / drop renamed), you may be able to avoid a needed rebuild index because of e.g relocated...

keep in mind sqlserver is actualy recreating your table and indexes and inserting the existing rows into it.

IO is your slowest operation.

btw you can script this operation with Enterprise manager...

it is actualy getting the resultset as well as the rowcount because that is returned as an outputvariable.

.

- problem with authshrink is that you don't know _when_ it is going to happen.

- autoshrink is active, and apps are still accessing the db, they will suffer, or even...

--Lets create SP1

CREATE PROC SP1

@NoRows int OUTPUT

AS

begin

set nocount on -- avoid unneeded network info

SELECT au_lname

FROM authors

SET @NoRows = @@rowcount

end

go

declare @Rowcount int

exec sp1 @Rowcount output

print @Rowcount

there was no problem with the proc.

using Return @Exists just means that you use the value of var @Exists as procedure-return-code.

DECLARE @rc int

DECLARE @pUsername nvarchar(50)

DECLARE @Exists bit

-- TODO: Set parameter...

Ahmed Bouzamondo (11/24/2007)

---

Hi ALZDB,

If I want to create the user JustProc on AdVentureWorks datatbase.

Please Just confirm the following:

1. Connect to an instance as the sysadmin

2. Create a new login JustProc...

http://www.sqlservercentral.com/scripts/Miscellaneous/31639/

The order of adding the parameters to the cmdobject is important ! (= order of parameters as used with the create procedure)

just add the login to your db (public) and then

you can grant it exec on schema.

This way _all_ schema bound functions and procedures are available for the login.

Also keep...

no, that is not needed.

in stead of the "set transaction isolation level" you

might use the "with (nolock)" table hint if you don't want

the scope to be proc level.

Anyways,...

or if you only want to trim leading or trailing spaces you can use :

SELECT RTRIM(LTRIM(mycol))

FROM myobject

Check out BOL for

DBCC SHRINKFILE

(

{ 'file_name' | file_id }

{ [ , EMPTYFILE ]

| [...

easiest way is to

select top 1 convert(varchar(23),datetimecolumn,121) as datetimestring

from yourtable

and copy/paste the result.

or use

Declare @wrkDatetime datetime

set @wrkDatetime = dateadd(d, -10, getdate()) -- today - 10 days

select...

Indeed within a sqlserver version (sql2005) you can move datafiles from 64bit to 32bit and visa versa.

keep in mind, once mounted on sql2005 you cannot detatch and attach

on sql2000...