I know that there is a group for reporting services, but have not been successful in resolving this problem. I get this error starting debug or preview with my report after adding inner join script because I needed another tables field: Must declare the scalar variable "@anyName" I have r...more >>

Hi, I get access denied errors when trying to do a backup or restore to a path based on the temp folder returned from the GetTempPath API. For instance: Cannot open backup device 'C:\Documents and Settings\user.DOMAIN\Local Settings\Temp\Asc\db_backup.bck'. Operating system error 5(Access i...more >>

I have run into != in some old problematic stored procedures I am reviewing and I don't remember ever seeing it before. Is it still used? Using SQL Server 2005. Nancy L ...more >>

Hi, I'm planning to use the snapshot isolation level instead of using "with no lock" in the Select statement. Since it is new with SQL Server 2005, I would like to know if there is any concern or recommendation about the snapshot? Thanks ...more >>

I have a database with a main table that I'll want users to be able to delete a row. However, there are anywhere between 5 and 50 children tables that might have corresponding rows (referencing that primary key in the main table). So I'll need to delete them too. Is there some voodoo that some...more >>

Dear all, I have heard that Linked server should be use only if you intend to process a read only operation on the remote server, but is not really dedicated for read/write operation. Is it the really the case ? Perfomance are involved in that case ? thanks for comments regards serge...more >>

Consider these four tables: TableA: Columns: ID (PK), Type (FK-TableA_Types), etc. TableA_Types: Columns: ID (PK), Name Table B: Columns: ID (PK), Type (FK-TableB_Types), etc. TableB_Types: Columns: ID (PK), Name TableA has a FK column to the TableA_Types table (TableA.Type...more >>

Hi, I'm trying to copy Data from one server to another of the same DB. Tried using "Export Data" option in SQL 2K, and i cannot export the data for every table in one shot as the step asks for the destination whether it's a "Result" or to choose the table name. I've 100's of table and expor...more >>

I've got a SS 2000 server with two instances of 16 cpus and MAXDOP set to 0 on both instances. When I got into Perf Mon, the Context Switching is 20,000+ day and night 24/7/365. My q's are: 1. Should MAXDOP actually be set to something smaller in this kind of an environment, probably 4...more >>

I've got a SS 2000 SP4 server at a new place I'm working. It has 16 processors (per Perf Mon) and has two instances on it. Each instance returns the following when I go into Ent Mgr and run sp_configure max degree of parallelism 0 32 0 0 When I go to Properties for the server and the pro...more >>

I have created a backup maintenance plan in SQL Server 2005. Is there any way to run/execute this SQL Server backup maintenance plan from VB.NET ? Thank you. ...more >>

Hi, I purchased the book Microsoft Access Developer's guide to sql server. Does anybody know the link to download the code that comes with this book. I searched the Sam's publishing page but did not find download. It will be of great help if I can find the code asssociated with this book. Th...more >>

I have a table that holds 5million rows. DDL: Nummin bigint, nummax bigint, city int, state int The numbers represent serial numbers shipped to different areas of the country. When a serial number comes in without a city assigned to it I need to lookup the city/state and update the re...more >>

Hi folks, Please advise how to extract column information of a table using T-sql. thanks. PeterK...more >>

Hi, I create a text formatted file using a stored procedure that has data rows plus a header and a trailer row. This is done by inserting the header, data and the trailer into a temporary table and then using BCP to create a text file that has the data in the order HEADER, DATA and then TRA...more >>

Hi folks, I am trying to create a CLR-stored procedure. First, I coded and created a dll. Then if I worked on the servder machine at home , I could create its assembly as below: ===> create assembly a1 from 'c:\myfolder\myTest.dll' But, in the work area, I execute the same code, as...more >>

I've been reading a lot of discussions on this, but I still can't get it working. I need to execute an Oracle sp from SQL Server via a link server. The Oracle sp has a couple of input parameters and an output parameter(P_OUT_STATUS OUT VARCHAR2). I tried many different versions of Ope...more >>

Hi I have a database on SQL Server Express 2005. The database contains about 950 tables. About 200 of those tables have duplicate records. In a duplicate table, each row has a copy of itself. I am trying to write a script which loops through all the tables in the database and deletes the du...more >>

Hello, following another example I found here I wrote the following Code in a stored procedure: CREATE PROCEDURE stProc_DSAnlegen .... @ID_Verf nvarchar (40) OUTPUT, @txtNummer int OUTPUT, @txtJahr int OUTPUT AS ..=2E. some other SQL-Statements ..=2E. ...more >>

Hi! I'm trying to convert explicitly a nvarchar variable to numeric but I guess I'm doing something wrong: Here is the variable declaration: Declare @projPercTimeElapsed as nvarchar(255) And the cast: Select @projPercTimeElapsed = CAST(@projPercTimeElapsed as numeric) Can some...more >>

Is it possible to increase the memory used by the SQL CLR ?? am getting error when am inserting 15 million records into array list in C# code of SQL CLR...more >>

Hi folks, I have to create an external database for a very well known mining application suite. Now because this software used to use a proprietry internal database, there are some funny aspects of the schema. One problem is that every table has to be declared twice in the database: TABLE_REA...more >>

Hi All I am trying to get the usage of each and every file in the database. I tried to use Fileproperty('master','SpaceUsed') function to get the file level usage. But I am confused with the output that I am getting. Master database has only one data file master.mdf. When I compared the resul...more >>

Hello, the subject of this post is not so wonderfully expressed - but I did not know how to put my problem. Here is a better explanation. I want to return the names of the twelve calendar months - without referring to any table in my database. So I would like to return in one column the val...more >>

Hi all, There is an existing table as create table t (c1 int, c2 int ) i want to add new column to table t between column c1 and c2. i had tried this SQL statement, its not working alter table t add cNew int after c1. This can be done by UI i.e. enterprise manager, but i want to do...more >>

I want to know how to write a tool like SQL Profiler, so I can trace everybody's operation , such as 'alert proc...','create table...'. Besides 'sp_trace_xx', I think thers is anything else would 'spy' better:) thanks a lot ...more >>

I have stored procedure which owner is dbo. In this procedure I insert some data into table. Then I have some user, which has execute permission on this procedure, but when I execute it with this user, I get the following error: "User does not have permission to perform this operation on tab...more >>