Use this tag for questions specific to the 2000 version of Microsoft's SQL Server.
I have a stored procedure on SQL Server 2000. It contains: select ... into ##Temp ... ... drop table ##Temp When I run the …
sql sql-server sql-server-2000 ado temp-tablesI would like to know what is the maximum size of varchar in SQL Server 2000. While I was googling somewhere …
sql-server sql-server-2000 varcharIs there a way to persist a variable across a go? Declare @bob as varchar(50); Set @bob = 'SweetDB'; GO USE @…
sql sql-server sql-server-2008 sql-server-2012 sql-server-2000Need help with this SQL Server 2000 procedure. The problem is made difficult because I'm testing procedure via Oracle SQL Developer. …
sql-server stored-procedures sql-server-2000 syntax-error dynamic-sqlI have a table with data similar to the following: [ID], [State], [foo], [DateCreated], [DateUpdated] The longer I work on …
sql group-by sql-server-2000 max coalesceI want to create a view in which I select something like the following: select id, name, 1 as active from …
sql sql-server-2000On Sql Server 2000, is there a way to find out the date and time when a stored procedure was last …
sql-server stored-procedures sql-server-2000The requirement is to execute SSIS package, when a file is arrived at a folder,i do not want to …
sql-server wmi sql-server-2000 ssisI have a trigger which deals with some data for logging purposes like so: CREATE TRIGGER trgDataUpdated ON tblData FOR …
sql-server tsql variables triggers sql-server-2000In Sql Server 2000, is it possible to return, via SQL query, a complete list of database roles that exist in …
sql sql-server-2000 sql-server-administration