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...
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...
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...
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 ...