Is "SQL Server Management Studio" an OLE Automation Server? If so, I would like to control it. Thanks. ---Frank ...more >>

hi is there a built in function that returns an int that can be set via the connection string? wud prefer to use a single function call that returns an int as this field will be inserted into almost all tables for audit trails. currently i'm using wsid() but that returns a nchar? would a ...more >>

Hi, I know it's quite common to use BIT fields for boolean values. CREATE TABLE tblTest ( door BIT DEFAULT 0, accept BIT DEFAULT 0 ) instead of: CREATE TABLE tblTest ( door SET('close','open') DEFAULT 'close', accept SET('no','yes') DEFAULT 'no' ) (By the way, I use MSSQL ...more >>

Hello: In my SQL Server databases I have complex related tables and views. There is any tool which allow you to see (print) this complex hierarchy of views and tables as hierarchical tree? Thanks, GB ...more >>

I have a table called Employee_Bios with the following: Bio_ID Employee_ID Bio_Text The Employee_ID comes from one of two tables...the Employees_Active or the Employees_Inactive table. So I have a multi-part question...I know, this is SQL 101 - maybe y'all can give me a lesson on best pra...more >>

Hi there, I have created a UDT using in VS2005 and below is my code for the UDT **************************************UDT***************************** Imports System Imports System.Data Imports System.Data.SqlClient Imports System.Data.SqlTypes Imports Microsoft.SqlServer.Server ...more >>

Is there a way for SQL to alert me when any of the drive spaces on the server become too low? I am sure that someone has a scheduled jobs that does this and would send out e-mails to notify someone. Thanks -Matt- ...more >>

Hi friends, I came across the recommendation to do checkpoint to flush a buffer pool out when doing massive modification in small chunks under simple recovery mode. Can someone elaborate a bit more on it? Is it reasonable? And why? Thanks a lot in advance. Alex ...more >>

Can you have a pintable and use a full-text search designed table? Thanks, Don ...more >>

i am writing a UDF which takes nvarchar(max) as input parameter. Can any one tell me what is the equivalent of this data type in C#. Thx ...more >>

I have a table that contains a date/time column and an integer column. I write to this table every 6 seconds. I am recording the datetime and a current phase (1-5) throughout the day. I want to query the table and list the start of each individual phase for the day. The phases are of varying ...more >>

I have confused myself and need some help clarifing how to weite the following statement so that 3 difierent results can come from the value of the passed Parameter. The parameter can have 0,1 or 2 as the values What I'm trying to get back is the records that are automated if the value is 1 ...more >>

Taking the view below, is a view reran each time it is requested or is there some sort of caching that would hold the dataset ready for the next request of the view? CREATE VIEW dbo.vwTodaysNeurologyAppts AS SELECT TOP 100 PERCENT PatientName, ResourceCode, ApptDate, ActivityType FRO...more >>

Hello Everybody, I have a Encryption - Decription Question. In my project we are getting an XML File from a vendor which has a credit card number in clear text. We use XML bulk load process to load table from xml file. How can i encrypt credit card number while storing into table. Also i...more >>

When I run the following stored procedure I get these results. My file has 24 rows in it. However I am uploading it twice for some reason. Stored Procedure: CREATE PROCEDURE [dbo].[dsp_Manual_Import] ( @PathFileName varchar(50), @SQL varchar(2000) ) AS SET @SQL =...more >>

I'm getting a little frustrated... I'm trying to write a stored proc... the following code works fine on its own in Query Analyzer... when I put it into my stored proc... SQL Server complains about the ORDERS BY clause. SELECT TOP 1 UserID FROM Users WHERE UserID > 50 ORDER BY Use...more >>

Hi - I am trying to use DTS (from EM) to copy tables, SPs and data from my remote SQL Server (2000) to my local copy. However, it keeps failing when I try with the SPs - and I think it's because one of them references a field my_tempemail which has been deleted from a table. Is there anyway...more >>

Hi I have a question. If I have a composite primary key on table (in essence I will have a composite clustered index as PK by default creates a clustered index) when would the Query optimzer would not use the index on it?. Is it like if the Query optimzer thinks that a table scan would be m...more >>

will a client application using ado.net get an exception if the command is executing a stored procedure that does a RAISEERROR in its tsql? ...more >>

Here is a trigger in a table that I am working on. Call it tbl1. AT the bottom of the trigger is an Alter Table statement which looks like it disables the trigger. My question is for the purpose of this Alter Table statement at the end of the trigger. I am not familiar with the logic. Doe...more >>

I just upsized my Access application (mail-order processing system) and linked to SQL server 2000 via ODBC tables links from an Access 2000 front end. By doing so the standard optimistic locking of SQL server 2000 comes into force and the option "lock edited record" on the Access Client gets...more >>

We are currently moving data using stored procedures and Linked server. However it takes too long (40 minutes for 600K records with 40 fields). I am hoping to shorten the time. Any suggestion would be appreciated. Example stored procedure: --Truncate destination table, then insert data....more >>

I need to retun the last inserted Identity value. - The SP below has a syntax error on the Set line. How can I fix it? create procedure stp_GetIdentity @e int output as SET NOCOUNT ON Set @e = Select @@Identity return go Thanks, Rich...more >>

Hi, We have an OLTP system with 600+ connections, 30 gb database running on a 4 CPU and 4.2gb memory, out of which 3.5 gb is allocated to SQL Server (using fixed memory). SQL Server is on its own dedicated machine. Our clients are complaining about performance. Disk utilization is around 5...more >>

given a simplified table like so: create table transactions ( transactionid uniqueidentifier primary key not null, datecreated datetime default current_timestamp /* just for you celko */ not null) go this query works: select datepart(month, t.datecreated), datepart(day, t.datecreate...more >>

The company I work for uses tracking software for entering help desk (IT-related) issues. The issues is timestamped and assigned a Priority level (A-D). Each level relates to an estimated completion time. What I'm trying to accomplish is to add the estimated completion time to the time and date....more >>

Hi, I am having one stored procedure named SP1 which is having one input and one output parameter as follows CREATE PROCEDURE dbo.SP1 @xmldoc TEXT ,@FLAG_EXEC VARCHAR(5) AS BEGIN ..... END I have write another stored procedure named SP2 which is creating a dynamic SQL ...more >>

Hello, I have le following c# procedure: namespace AXRON.SqlServer { public partial class StoredProcedures { [Microsoft.SqlServer.Server.SqlProcedure] public static void pSoloDldCreateTables() I would like to insert it in my database with the following request: C...more >>

I have two fields of type datetime - a DateStart field and a DateEnd field. Is it possible to use some SQL to return each of the dates between these 2 dates? Thanks *** Sent via Developersdex http://www.developersdex.com ***...more >>

Hi friendz, I've the following procedure & the table stockexcdownload contains at least 4,00,000+ records. My requirement is that this proc. is costing me about 10 mins to process these many records. I'd also have an index on this table. (given below) suggest me on how to optimize thi...more >>

I am transferring some queries from Access to SQL Server stored procs. I have a problem with an update query. I dont understand whats wrong with this: UPDATE #qry_IS_DomCareVar10 INNER JOIN #localtbl_DomCareVar ON #qry_IS_DomCareVar10.DEALITEM = #localtbl_DomCareVar.DEALITEM SET #local...more >>

Environemnt: SQL 2000 SP4 Windows 2003. I am looking for a way to check what permissions a user has in a specific database. For example: I am logged in as a login ABC and I want to know a login XYZ has what sort of permissions on Database DB101. I also need to know if this user is a membe...more >>

Hello, I need to do a relation between 2 tables with this request (under SQL server 2005) ALTER TABLE "dbo"."PrmBox" ADD CONSTRAINT "FK_OrgSet_PrmBox" FOREIGN KEY ("n_oset") REFERENCES "dbo"."OrgSet" ("n_oset") on update cascade on delete cascade But I have the error : .... may cause...more >>

I want to create a custom aggregate to calculate percentiles. For example: The 50th percentile is calculated by extracting the value(s) in the centre of a sorted dataset. What I need in this case is a sorted dataset so that I can extract values at specific indexes to be able to calculat...more >>

Yes, I know this is a silly situation. I have an application that uploads several tables to a remote SQL Server that is part of a web site. The records are uploaded into a dedicated upload table, then the table they belong in is truncated and the records copied using INSERT INTO ... (SE...more >>

We have a new application were building which includes a module to preform overnight processing. Originally the idea was to schedule a job on the server to run for each database that needs the processing completed. Whats the best way to do this? we are using vs 2003, ms slq server 2000 ...more >>

my problem is about trigger update on master-detail. i have tables as follows: account ------- year (int) accountno (nchar) balance (money) master ------ tno (nchar) tdate (date) .... detail ------ tno (nchar) accountno (nchar) amount (money) .... if there is any changes on...more >>

Hi! This is probably simple (or impossible) but I can't figure out how to add to values into 1 in a result. Something like this: select sum( lala ) as sum_1, sum( lele ) as sum_2, add( sum_1 + sum_2) as sum_tot from myTable I could ofcourse use lala and lele in a new sum ...more >>

Hello, I have to filegroups like database_data1 stored on d: database_data2 stored on e: How can I delete the database_data2 and tell SQL 2005 to copy all data to database_data1? Thanks for any help in advance! A. Klemt ...more >>

Can you change the column id of a column using a statement? Its no problem if you use the Enterprise Manager -just drag til column in design mode and it has a new id. However as it can be done in EM it should be possible using a statement aswell I guess. Column definitions are found in mast...more >>

Hi all. Is there a way I can have my resultset saved to a file directly from a SP using SQL2000. E.g. use northwind CREATE PROCEDURE ToTxt AS SELECT * FROM Customers /* I want something like*/ /* SELECT * FROM Customers TO c:\Cust.txt */ /* Then I can run the following to create...more >>