I've got cross database joins in s-procs and triggers. For ease of deployment I would want to refer to db names through a variable but I have tried this without success: a rough e.g declare @db_name varchar (20) set @db_name = 'my_database' select * from @db_name.tbl This is for MS SQL ...more >>

SQL Server 2005 Enterprise. I had tried to take a database offline, then cancel it midway as it seemed to take very long. Now I cannot connect to this database. How can I restore this database? Thanks, Bubbles ...more >>

SQL Server 2005 Enterprise version. I have a stored procedure that executes several stored procedures. The SPs were set up individually for ease of debugging, then run as a batch. Individually and as a batch, they run fine. How do I set up this SP to run as a scheduled batch? I need to ru...more >>

Is there any equivalent of Oracle's Sequence in SQL Server 2000/2005? Or can I emulate it somehow? Thanks, Amir Mahmood. ...more >>

Hi, I have some temp tables inside a stored procedure. Is it good practice to explicitly drop these temp tables at the end of the stored procedure or will MSSQL drop them for me? Obviously, best practice would not to have temp tables in the first place but I am unable to avoid this scenario. ...more >>

Hi, Could anyone please help me write a SQL 2000 compatible query for the following query. The following query runs perfectly on SQL 2005, but NOT on SQL 2000. --- select t.name, c.name, c.is_computed from sys.columns as c join sys.tables as t on c.object_id = t.object_id where c....more >>

I have a table that looks something like this: CREATE TABLE [dbo].[Counter]( [ID] [int] IDENTITY(1,1) NOT NULL, [Date] [datetime] NULL, [Count] [int] NULL, [Product] [int] NULL ) ON [PRIMARY] Given a specific date (today), I want to sum the values in the [Count] column (starting wit...more >>

Hi all, ISSUE: ==================== In SQL 2005 (sp2) I get the following error when preforming a bulk insert with an associated xml format file: "Could not bulk insert. Unknown version of format file" Question: ==================== I am unsure what they mean by "unknown version". Spec...more >>

I have stored procedure that is doing alot read high I/O, it is doing clustered index scan on the Order Summary table. here is the text of the SP. Can you please help identify what index I need to add or change the way the stored proceure are writen. Thanks in Advance! ----------------------...more >>

I have stored procedure that is when executed , it does Clustered Index Scan on he below table with alot of read . the Table JDEOrderSummary has over 3 Million record. Here is the DLL for the table . Can any one help me identify what column should be indexed to be able do clusterd index seek a...more >>

SQL Server 2005 express. Two questions..... 1. What are default permissions of the owner of the schema with regard to objects (tables, stored procedures belonging to particular schema)? Same for database owner? Will the owner have all permissions by default or do i need to explicity grant pe...more >>

Is it possible to pass a table's column name as a parameter to a UDF which returns a table? I just need a rough syntax something like select * from dbo.split(select [name] from employee,' ') ...more >>

Hello, I'm attempting to calculate FIFO cost for outgoing items from my Inventory Transactions table. The table has a TransactionType field that indicates the transaction is either (1) items received (positive), (2) an adjustment (positive or negative), or (3) a sale (negative). It also has...more >>

I am trying to Order results from a stored procedure depending on the columns that the user clicks on the DataGrid. The user end works fine, but I cannot get the sorting correct in my Stored Procedure. At the momnent I use a variable called @SortBy and then use this code in my Stored Proced...more >>

/* This is only for example, but my database has to have many values and queries like this. */ I have a table named "table2". Its create statement is below: CREATE TABLE Table2 ( [id] int IDENTITY (1, 1) PRIMARY KEY CLUSTERED, [value] ntext COLLATE SQL_Latin1_General_CP1_CI_AS NULL ...more >>

Hi, We have stored proc name proc_test(str nvarchar(30)). So far this proc has been invoked from a .NET application assuming that only English character strings will be passed to it. The calls are like proc_test('XYZ') We now have a requirement for passing Chinese strings as well. Rather tha...more >>

Hi. I'm trying to build a field from the values in 4 other fields. The four fields contain 0's and a 1's to mark involvement in a project. So the table looks about like this: CompanyName: Microsoft Inc. ContactPerson: Bill "Humor me" Gates Is_involved_in_watergate: 1 Is_involved_in_iRack:...more >>

ALTER FUNCTION [dbo].[fn_KPI_GET_EXCL_PRODUCTS] ( @CustomerID int ) RETURNS TABLE AS RETURN ( IF (SELECT COUNT(ProductCode) from dbo.KPI_PROD_CDE_EXCL AS ProductCode WHERE CustomerID = @CustomerID) > 0 BEGIN SELECT ProductCode from dbo.KPI_PROD_CDE_EXCL AS ProductCode WHER...more >>

CREATE TABLE [dbo].[tblManyToMany] ( [Ord] [char] (10) NULL , [Inv] [char] (10) NULL , [FrtKey] [char] (10) NULL ) ON [PRIMARY] GO INSERT INTO tblManyToMany Values('1','1','XYZ') INSERT INTO tblManyToMany Values('1','1','ABC') INSERT INTO tblManyToMany Values('1','1','DEF') INSERT INTO...more >>

Hello, We have two Windows 2003 servers one running IIS and another for SQL Server. We are at a stage where we need to load balance and provide a failover. Can you show us a technical document which can help us do that? Thanks. -jay ...more >>