ok, I just realized that the shortcut command you needed was for {slash L}, not {slash R]

ROWTERMINATOR =

vbCrLf = CHAR(13) + CHAR(10) = \n

vbCr = CHAR(13) = \r

vbLf =...

why not just call the file directly? why do you have to do the cd command, when you know where the file is anyway?

create table #Results (

ID int identity(1,1) NOT...

Tara-1044200 (8/26/2010)

---

can i create a sql role and add some users(50+) and give them only read access to all the databases in the server. What would be the best way...

i have this CREATE TABLe in my snippets, so i would assume drop table works the same way:

EXEC sp_addlinkedserver 'SeattleSales', 'SQL Server'

GO

EXECUTE ( 'CREATE TABLE AdventureWorks2008R2.dbo.SalesTbl

(SalesID int, SalesName varchar(10))...

this is completely untested, as you didn't provide the schema or sample data.

note i'm assuming there is a column "remarksID" so the list of remarks can be ordered....only YOU know...

we cross post each others same answers just a bit too often 🙂

i don't think the CREATE USER command allows variables; you'd have to switch to dynamic SQL instead:

declare @groupname varchar(50),

@sql varchar(1000)

SELECT @groupname =...

scottichrosaviakosmos (8/26/2010)

---

i have a table and i am writing a procedure. my table has a unique column eg:u_column .

Now, i want to know on which u_column its which columns are...

you want to read the windows registry to get the collation before the installation, i think?

I'm only sure of how to get it afterwards....maybe you could run a script to...

doh the script i posted was coded for tempdb specifically, this will work in any old database:

SELECT

SCH.schema_id, SCH.[name] AS schema_name,

...

run my script against any database; look at the column...

for files originating from unix, i've always used ROWTERMINATOR = '\r' ({slash r} if the forum doesn't like to print it),

otherwise regualr PC files get {slash n}

sys.index_columns has a 0/1 column named is_included_column;

here's a script example that pulls some of that info out into a comma delimited list that i use for scripting out indexes:

SELECT ...

also if you don't actually turn off the original satellite servers, change all the databases to read only on the old servers the moment you switch over;

it will help...

what i...