i want to check given input date as valid date or not. input date fprmat like dd/mm/yyyy using functions....more >>

hi , i wrote one stored procedure that will return 9000 character as output string but it support only 8000 varchar what should i do it should be used ASP.NET Menu Generator from database sp -- s.senthil kumar...more >>

is there any way to do this to run say a stored proc as this user from QA to verify permissions etc? (the password for ASPNET account is unkown, as it is managed by windows) i know i could use roles as a workaround (e.g. add ASPNET to a test role, and a QAuser to same role & assign database pe...more >>

Hi, I have 2 seperate queries from a nested table structure. This query returns the emp and his subordinates. [code] SELECT s2.*, dbo.Employee.FirstName + ' ' + dbo.Employee.LastName AS Emp_Name FROM dbo.Stack1 s1 INNER JOIN dbo.Employee ON s1.employee ...more >>

Is it possible to expose a multistatement table-valued function or inline table-valued function as a web method with CREATE ENDPOINT on SQL 2K5? I've been able to create web methods on stored procedures and scalar UDF's, but so far no luck with table-valued functions. Also can't seem to find...more >>

i am reading up on how the log file works and i wanted to confirm here what i have just read if the power went out and my database was in the middle of transaction the system would roll back the transaction when the server starts up again. if the power went out and my database had writ...more >>

Do you know, Im sitting here tearing my damn hair out over trying to learn SQL 2005 Server. It seems like each time I try to do something, I'm prevented from it. OK, enought rant. . . . . I create two sql users but when I tried to sign on, it told me I needed to change my password, which...more >>

Im a little confused about schemas in SQL Server 2005. I have read a couple of articles on it but it still does not seem to have hit my cognative subroutines with any cogency. Here is what I know. 1.) You can define schemas like Sales, Personnel, Accounts etc and group objects like table...more >>

I was trying to copy a database to a new name on the same server and kept having problems. Initially, it was complaining that there were missing transaction log entries. This was strange since I was loading a backup from 5-6 months ago and never asked for a transaction log to be restored. ...more >>

I would like to sort a store inventory id field such that it sorts the alpha part first and then the numeric part. So I have: A6 A2 A13 BR2 B3 And so I want to sort first alphabetically (A, B, etc.) and then numerically (A2 before A13, etc.) so I end up with: A2 A6 A13 B3 BR2 I a...more >>

I run an embedded query to compute a Yield and display output. The result is singleton. A Yield is the OutFeedTotal divided by the InputTotal. Though the Infeed should never be less then the Outfeed (the process reduceses the product) occasionally there is a malfunction that makes this pos...more >>

Can anyone confirm that it is not possible to INSERT/UPDATE into a view on one database that references a view on another database (same server, different dbs)? Thanks...more >>

Good morning. I am importing an XLS file into one of my tables. The fields are: Date Id Time IO 12/22/2006 2 12:48:45 PM 9 12/22/2006 16 5:40:55 AM 1 12/22/2006 16 12:03:59 PM 2 When I do the import, I get the following: Date Id Time IO 12/...more >>

Hellow i am senthil i put one identity column in application table after entering data in that table some days later i could sea that identity column it jumbed 1,2,3,4,5,203,204 how it is possible , server not reseted,machine not shout down ...more >>

Hi I have troubles with a threaded application on W2003 server. It seems to leave open connections behind time to time, it sums to hundreds over a day (the application make thousands). It is using the SQLOLEDB provider, MDAC 2.82.1830.0, SQL Server 8.00.2039 (SP4), Windows 5.2 (3790). i am...more >>

Hi, I have a multithreaded application where each thread executes a SQL Query which has same Cursor defined in it. Suppose if my declared cursor is as below: e.g. I want to access all the database names. So, I'll create following cursor: DECLARE AllDatabaseInfo CURSOR LOCAL FOR SELECT name...more >>

Hi, How do I display the relationships in my database? When I try to open the Database Diagrams list, nothing is shown. It appreas that there are no diagrmas created. Still, there are relations between tables. So, how do I display the existing relations in the database? I hope that I don't ...more >>

Hi Everyone, I have a question about dynamically changing the length of a varchar(n) field, in case the value I'm trying to insert is too big and will give a "truncated" error, but before the error is given! i.e. Is there some kind of a way to "test" the length of the field while Inserting the...more >>

Hello, How can I trap the respective DML error and write it to file in the local disk? CREATE PROCEDURE [dbo].[ClearEmployeeAccounts] AS BEGIN --Copy data to Employee_Load_History INSERT INTO dbo.V_Employee_load_history (col1 , col2) SELECT col1, col2 FROM dbo.V_Employee_load IF ...more >>

Hi, In MS SQL Server 2000 online help book, the sample: CREATE TABLE TestTran (Cola INT PRIMARY KEY, Colb CHAR(3)) GO BEGIN TRANSACTION OuterTran -- @@TRANCOUNT set to 1. GO INSERT INTO TestTran VALUES (1, 'aaa') GO BEGIN TRANSACTION Inner1 -- @@TRANCOUNT set to 2. GO INSERT INTO TestT...more >>