Hi Experts
How can I use 'top' in an sp_executesql command.
This statement works fine :-
exec sp_executesql N'select * from dbo.amc_adm_deployed_node where deployed_node_id < @P', N'@P ...
Hi,
I created a table as below,
create table testInsert(testNo int,testName varchar(50),testDate datetime)
Now i want to alter column testNo to add identity(100,1).How can i do this in quer...
Hello,
Is it possible to either override the T-SQL getDate function, or change some SQL settings so that getDate always returns UTC (rewire getDate up to getUTCDate).
I would like to en...
HI ALL,
I have a table name contact in sql server 2000, having fields, email,Fname,age,LockId,FlockId,parentId etc. Now, I want to see all the records from contact where duplicate record...
Hi, I am new to SQL and need some help with temp tables and iteration.
Here's what I have:
1. Master table name = ncmr
2. Table I'd like to update = workflow
In summary here's what I...
I have a couple of question.
Does MS-Sql 2000 automatically pick the correct index on a SQL Statment?
If it does is there anything I have to do to get this to work?
I have a table (very...
Is there any way to garnt permissions to all DB tables at once ???
I wrote the following code:
USE MyDb
GRANT all
on Table1
TO MyUser
The problem is that I have many tables in my DB...
Okay all, here is my question. I have a file that is carrot delimited (^). There are quotation marks for a text qualifier ("text"). The data comes from a legacy system and some people accid...
Hi Folks,
I have a DTS package setup to read some fields from a text file (source) and upload into a DB table (Destination). Simple stuff. When setting up the DTS package in the designer,...
Hello all,
I have an international DB, and I want to represent the numbers in it in different ways for different users.
For example, the number 123,456.789 may be displayed as 123.456,789 or...
Im trying to transfer a database to production using DTS, I get the following error.
----------------------------------------------------------------------------------------
There is alre...
I need help deriving a sql statement that can select a specific criteria from my database.
<%
Set Con = Server.CreateObject("ADODB.Connection")
Con.Open Application("DSN_Pipeline")
Set...
Hi There!
My sql server box become unresponsive at some point. When its un responsive i can not even ping it. How can i setup a sql server 7 so that it will alert me whenever somethin...
Hi,
When I check the log file space allocated map it shows that the used part is about 20MB, however the free part is overgrown to something like 2GB.
Have you ever experienced anything ...
Hi,
I've got an SQL server table that is linked in Access 2002. There is an ODBC connection on my computer to the SQL table. It connects just fine and brings up the table. However, after ...
My query analyzer has this annoying disposition to only allow me to enter dates using the american date format standard (mm/dd/yy). The strange thing is that my machines regional settings are ...
Hi, I have a Active-Passive Sql cluster running (Microsoft SQL Server 2000 - 8.00.818 (Intel X86) May 31 2003 16:08:15 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on...
Is there a Microsoft SQL version of the Oracle Least() function? In particular I want to return the lesser of two dates as a column in a select statement.
Scott Ewine
I need to be able to take a search term and search for it in a column in a very specific way. That term must not be preceeded by anything except leading zeros and no other character, and must...
Hi,
I need to grant some server roles to a DB user (system administrators, Security administrators etc').
What is the SQL query to do so....
ok. This is what i need. i hv a database with four columns. (say, heading1, heading2, heading3, heading4). i want to be able to search the fourth column (heading4) for specific words entered b...
Hai Everyone,
When i am trying to send mails from our exchange server , In Inbox i am getting an Bounce back mail stating that "No transport provider was available for delivery to this recip...
I have written a stored procedure(MS SQL Server 2000) which accepts parameters and returns recordsets
I am trying to access the stores procedure some what like this
execSP = "ressp ...
I am working on writing a DTS package that imports from 5 different text files. I have written an ActiveX VBScript task that uses the FSO to check for the existence of the fiels prior to movi...
Hi guys,
I made a call from sp to dts pkg, everything works 100% in test server, on my live db I run into problems, changed from trusted connetion /E to specifying the username and password...
