sys.servers - what table was in SQL 2000
Hello, In SQL Server 2005 in the sys.servers information about mapped remote SQL Server instance is stored. How were remote servers mapped in SQL Server 2000? BR, Adam ...
sql-server-2000
T-SQL Statement needs improvement.
I have the following T-SQL code (in SQL 2000) which functions correctly: INSERT INTO M2MDATA01.dbo.cspopup (fcpopkey, fcpoptext, fcpopval, fnorder, fcpopacces) SELECT CSP69.fcpopkey, C...
How to call MySQL Stored Procedure from SQL Server 2000?
I have two databases, one MySQL 5, one SQL Server 2000. I've got the MySQL database mapped as a linked server in the MS SQL database. I'd like to call a stored procedure saved in the MySQL database from the MS SQL database. What's the correct syntax to do this? Is it even possible in SQL Server 2000? Edit: I've tried EXEC webpush......
SQL Server Bug?
Hi There, I am writing a function to process some CSV data. This is what I have written so far... CREATE FUNCTION dbo.FGetCommaSeperatedValues(@csv as text) RETURNS @tblIds TABLE(id int,csvlength int) AS BEGIN DECLARE @csvlength AS int --SET @csvlength = datalength(@csv); SET @csvlength = 7685 DECLARE @currentIndex AS...
When restoring a database in SQL Server 2008, how to ignore the users ?
I am importing a SQL Server 2000 database to my SQL Server 2008 server. I don't want to import any user/permission information, is there a way to ignore this? The current restoration is causing me issues as it has users tied to the db. ...
Copying Databases Between Servers
I know this isn't recommended but my development server is 2008 while my production server is 2000. What is the easiest way to copy databases back and forth? For example, I just created a database with a robust date table which I intend to use in my queries. I figured the easiest way would be to back up the database and restore it t...
Get current connection protocol in SQL 2000
I'm currently using SQL 2000 (it's a vendor server - don't ask...), and I'm wondering if there's a way to detect the connection protocol of connected clients. For SQL 2005+, I use: select net_transport from sys.dm_exec_connections where session_id = @@spid But SQL2000 lacks this dynamic view. Anybody know the equivalent function on S...
First Day of Next Year for SQL Server?
This should not be this hard. I simply need the following: SET @DueDate = CONVERT (DATETIME, '01/01/2010') However, I need it programatically so that if it were March of 2010, the date given would be '01/01/2011'. I know it's simple, but my brain isn't coming up with it. I'm sure it's with a DateAdd and getdate(). ...
Without stored procedures, how do you page result sets in ASP.NET?
Without stored procedures, how do you page result sets retrieved from SQL Server in ASP.NET? ...
Single or multiple INSERTs based on values SELECTed
We're extracting booking information for our tennis courts from our SQL database into a simple results table to help us build a picture of court usage. It's pretty straight-forward except when it comes to bookings that last more than an hour. At present, each booking results in a row in our results table. Each row contains a start-time,...
Multiple inner joins in SQL 2000
I'm in the unfortunate situation of developing an app using SQL Server 2005 in the development environment but SQL Server 2000 on the production server. I have a fairly complex SELECT query which works fine on the development/test server but falls over in the production environment: SELECT tbl_questions.Question, tbl_questions.Question...
4-4-5 Accounting Periods are the Bane of my Existence
We use 4-4-5 Accounting Periods. In case you aren't familiar with this, you can find info at Wikipedia. To accomplish this, I created a date table with all the days for the next 10 years. I used the script (albeit modified) found here. The creation script for my table is: USE [RedFridayDates]; GO SET ANSI_NULLS ON; GO SET QUOTED_...
SQL Server 2000 TSQL : Stored proc results into table
I would like to get the out put of a stored proc call and create a permanent table with out specifying columns. Because the stored proc return lots of columns... So.. how can I do this?? SELECT * INTO MYTABLE FROM MYSTOREDPROC @PARAM1 = 1, @PARAM2 = 'HELLO' is it possible?? Example would help me alot ...
Can Visual Studio 2008 provide any of the functionality that Query Analyzer and Enterprise Manager provide?
I'm currently using MSSQL Server 2000 and to design tables, create and alter stored procedures as well as manage users and permissions I'm using Query Analyzer and Enterprise Manager. I also spend an awful lot of time in Visual Studio 2008 and rather jump out to other applications I was wondering if Visual Studio could help me do at leas...
Query Optimization - Why does this speed up the Query?
I'm using Quest's TOAD for SQL Server on a SQL Server 2000 Server. Here is my query: SELECT CASE SLCE.GroupName WHEN 'Other' THEN ARM.FBCOMPANY WHEN 'Inter Co.' THEN ARM.FBCOMPANY ELSE SLCE.GroupName END AS [Company Name], ARM.fcustno AS [Cust No], ARM.fbcompany ...
Find an instance of a character in a database
Is there a relatively easy way to find an instance of a character, say a "|" or a "~" or a "&", in a database? It could be in any field...in any table. There are around 400 to 500 tables in the database in total. ...
getting error in SQL Server 2000 but not in SqlServer 2005
Hi, I am executing a stored procedure and i got an error saying 'Error SQL Server Database Error: Error converting data type varchar to int." in sqlserver 2000. But when I execute the same stored proc in Sql server 2005,i am not getting any error and result is getting displayed. Any one is having idea regarding this??Please do help me....
How to get rid of extended table properties in SQL Server 2000?
I'm re-casting a question I asked earlier now that I have an idea of the cause of the problem I'm seeing. What I have: Tables in a DB on SQL Server 2000. I view/edit the tables with Access 2007, with SQL Server Management Studio 2005, and occasionally with SQL 2000 Enterprise Manager. What I did: I tried to copy the DB from SQL Serv...
Resolving a bug in the TDatasetProvider (the hard way) in Delphi 2010 or Delphi 2009
Hello Folks, Like every year I receive a new Delphi version as SA owner and this is what I do : Install delphi version XX. Run delphi version XX Insert a TSQLConnection component. Connect it to a Microsoft SQL Server 2000 who will be with us at least for six more years. Insert a TSQLQuery with a 'select top 1 * from myTable' which is...
How is fill factor physically allocated?
I've been trawling books online and google incantations trying to find out what fill factor physically is in a leaf-page (SQL Server 2000 and 2005). I understand that its the amount of room left free on a page when an index is created, but what I've not found is how that space is actually left: i.e., is it one big chunk towards the end ...