There is a server using MSDE
I would like to shrink the following database (TWO) using the following line of TSQL code.
DBCC SHRINKDATABASE (TWO, 10)
Is there a way to do this using cmd...
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...
Here is my SQL
if object_id('tempdb..#pivot100', 'u') is not null
drop table #pivot100
CREATE TABLE #pivot100 (deal_mid int,MoodysCurrRating varchar(255),cusip varchar(25),issuer varc...
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...
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...
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...
I need to drop a FK CONSTRAINT only if exists.
How do I write the "If.." statement before the following sentance:
...ALTER TABLE MyTable DROP CONSTRAINT FK_Mykey
Thanks in advance
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...
Hi guys, I am new starter for sql server, I met this problem I could not understand, Is anyone can help me please. I tested the database connection is all right, but when I try to insert some ...
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 ...
