Hi All, I want to have incremental data on a secondary server from a primary server. One option which I have thought of is "To add a timestamp field to all the table" and use DTS to get it. Please can you tell me is this the best way. Please tell me if you know anything better than thi...more >>

If I backup a file directly to the hard disk without creating a Backup Device I can still specify a Media Name and Media Description. I can then view the Media Description using th following query:- RESTORE LABELONLY FROM DISK = 'c:\test.bak' Can I do the same with SQL DMO? I tried the fol...more >>

Hi there, I have a stored procedure that uses a dynamic statement and executes it using SP_EXECUTESQL. When I call the stored procedure from another script and set the output of the stored procedure to a variable, the variable contains nothing. Can you please help me with this? The scrip...more >>

Hi, 1- Can we use a 'data type' AutoNumber? If so how? 2- Is it possible to have a field of type Date or Time separately (Not DATETIME)? I just want to store the dates. 3- When I use the data type "MONEY" four digits appear after the point, while there should be two. 4- Can we create DOM...more >>

I AM NOT ABLE TO UNDERSTAND HOW TO FINE THE NUMBER HOW MANY TIMES A SUBSTRING IS REPEATED IN BASE STRING FOR EXAMPLE TAKE THE STRING "KALYAN" I HAVE TO FIND HOW MANYTIMES 'A' IS REPEATED IN IN "KALYAN" USING A SYSTEM DEFINED FUNCTION ( I SHULD NOT WRITE A STORD PROCEADURE) ANY ONE PLEASE HELP M...more >>

Thanks for all your replies on my question. What I wanted to know is how do you get a unique machine ID (numbers and\or letters) of the server that SQL Server is running on. (Not the server name). For example, motherboard or CPU ID or something similar. Thank you Jannie *** Sent via Deve...more >>

Hi all, I have a date range that needs to be used by a variety of different views in a database that provides monthly SLA statistics. The existing views have verbatim calcs for the date range in each and every view. Steve Kass provided some great logic for calcuating a @start and @fini...more >>

DEV ENVIRONMENT: .NET and some COM DATABASE: SQL Server 2000 CLIENT OS: Win2K, WinXP SERVER OS: Win2K3 Greetings, I have a client who insists on having their customers in separate SQL databases for an online component. I instinctively feel that a consolidated database for all clients is ...more >>

We get the below error when running as a non sys admin account Does any one know what this is about i think its something to do with running the xp_cmdshell [Microsoft][ODBC SQL Server Driver][SQL Server]xpsql.cpp: Error 87 from GetProxyAccount on line 604 some saidto run this exe...more >>

Does any one know what this is about i think its something to do with running the xp_cmdshell [Microsoft][ODBC SQL Server Driver][SQL Server]xpsql.cpp: Error 87 from GetProxyAccount on line 604 some saidto run this exec master..xp_sqlagent_proxy_account N'SET', N'DomainName', N'Us...more >>

I've seen a similar question asked, but not answered before... perhaps I'll be luckier than the others? :) Basically, I am trying to achieve deferred insertion into a rowset: insert multiple records in a single round trip to the server. To do that, I open a rowset with DBPROP_IRowsetUpdate on ...more >>

Hi all, sorry for what will be to some a simple question. I am looking to find some sample queries/scripting that will select a date range of the current month for the current date less X (where X is a constant number of days). e.g. if it was 2nd December and X was 4 then it would ...more >>

Here's the senario. I have a list of users who have received services during the year. I need a report that gives me the languages they speak both year to date and month to date. The challenge for me is to figure out how to output something like this: Language MTD YTD English 2 ...more >>

I keep seeing references to "using cursors" in many posts and I am trying to understand exactly what a "cursor" is? I've been going through BOL thinking that would help but parts of those articles only added to the confusion. For example, one section in BOL is as follows: ---------------------...more >>

regardign finding out if an object (such as a SP or a UDF) is used anywhere in a database ... i suppose one method would be to script the entire database and then load the .sql file into a text editor and search for the object but perhaps there is a better way ? ...more >>

Hi All, I have a problem... I have duplicate field values that are causing Duplicate Records in a sense. Examples: -------------------------------- CREATE TABLE VTable (vid VarChar(100), vname VarChar(50)) Insert into VTable (vid, vname) Values('1', 'bill') Insert into VTable (vid, vname) V...more >>

I have a table being replicated with two columns named "effdate" and "termdate" which have a datatype which are smalldatetime. The value for "effdate" is 10/1/2002. The value for "termdate" is 12/31/2078. On my production server when I query this table it returns the values "2002-10-01 00:00...more >>

hi Experts, i have a problem in executing a sp through Query Analyser and ASP command object. The execution time of sp in Query Analyser is taking 2 sec and the same exec statement is getting time out through ADO command object in ASP. exec USP_ENQUIRY_SEARCH @ENROLMENT_NO='BLR',@GROUP_NA...more >>