sql-server-2000

Aliasing a linked server?

I have a server which I need to have as a linked server to another server, using sp_addLinkedServer. My server's name is in the format "DepartmentName.CompanyName.com", which I can usually change to [blah.blah.com], but which I can't use in the SQL Server Management Studio View creator, because it keeps deleting my square brackets... O...

What exactly does the T-SQL "LineNo" reserved word do?

I was writing a query against a table today on a SQL Server 2000 box, and while writing the query in Query Analyzer, to my surprise I noticed the word LineNo was converted to blue text. It appears to be a reserved word according to MSDN documentation, but I can find no information on it, just speculation that it might be a legacy rese...

Exporting tables and indexes from one SQL Server 2000 database to another

I have a SQL Server 2000 database and some tables in a database. I want to export them (the structure, definition and indexes) to another database. I don't want to copy the entire database, only some tables. And it doesn't matter the data that I have in the tables. Is there a form to do it?? I know the export data option but I've tri...

SQL Server 2000 varchar(8000) truncate to 256?!!

Hi All, I have SQL Server 2000 and I have a stored procedure that has @output as varchar(8000) and I have a loop that keeps concatenate the result into @output and at the end I made select @output My problem is the output length is truncated to the first 256 characters only!!! Other characters (output) is missing. I tried to use TEXT ...