Viewing 15 posts - 2,986 through 3,000 (of 3,221 total)
Start by reading Books On Line (BOL)
URL for linked servers is:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/6ef578bf-8da7-46e0-88b5-e310fc908bb0.htm
July 19, 2008 at 12:43 pm
The application role and control of same has changed from 2000 in 2005.
Sample code from BOL
DECLARE @cookie varbinary(8000);
EXEC sp_setapprole 'Sales11', 'fdsd896#gfdbfdkjgh700mM'
, @fCreateCookie = true, @cookie =...
July 19, 2008 at 10:58 am
Try this:
SELECT Name, MAX(Subsqno),SerialNo FROM TbL01 GROUP BY NAME,SerialNo HAVING COUNT(Name) = 1
UNION
SELECT Name, MAX(Subsqno), SerialNo FROM TbL01 GROUP BY NAME,SerialNo HAVING COUNT(Name) >...
July 18, 2008 at 3:45 pm
SultanKahut
I have experienced the same error message, starting a week ago, it occurs around 9:30 PM. Shut the machine down and was notified that an automatic update was...
July 18, 2008 at 11:41 am
Created the function using copy / paste / execute - no reported error then tested using the following:
DECLARE @Bdays AS INT
SET @Bdays = dbo.fn_GetBusinessDays('07/06/2008','07/27/2008')
SELECT @Bdays
Result returned 14 ..
Now counting...
July 18, 2008 at 10:55 am
Using OpenRowset as:
INSERT INTO myTestOrder
SELECT Col1, Col2, Col3, SUBSTRING(Col4,1,3)
FROM OPENROWSET(BULK 'C:\myTestOrder-c.txt',
FORMATFILE='C:\myTestOrder.fmt'
...
July 18, 2008 at 10:23 am
Steve thanks for a good question. It introduced myself and I imagine many others to a new or little know facet of SQL Server 2008 and in that way...
July 18, 2008 at 9:50 am
I too have been asked (directed) to improve my softskills, since I have the unskilled propensity to tell the truth. The request of me to improve frequently occurs right...
July 17, 2008 at 4:36 pm
i mean the latest ones should be there in the destination columns
What defines the latest ones?
Is it the column SUB-SEQNO value
or
Serial No values
or
some combination...
July 17, 2008 at 4:07 pm
May I ask you a question. Why upgrading to SQL 2000, particulary the most expensive version? This will still leave you 8 years behind the existing technology. ...
July 17, 2008 at 3:12 pm
You do not say if amongst these 100 user tables when created or later altered have been defined with
[ FOREIGN KEY ]
...
July 17, 2008 at 2:47 pm
ANJAN.ASHOK try reading this from BOL:
Getting Started with Full-Text Search
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/fulltxt9/html/1fa628ba-0ee4-4d8f-b086-c4e52962ca4a.htm
It gives an example using the AdventureWorks database. It is reasonably detailed enough so to get you going.
You...
July 17, 2008 at 1:54 pm
Aveerabadra
I am not that familiar with SSIS but I see you are using
(DT_DBTIMESTAMP)(SUBSTRING(DT,7,2) + "-" + SUBSTRING(DT,5,2) + "-" + SUBSTRING(DT,1,4))
have you tried using DT_DBDATE instead of DT_DBTIMESTAMP...
July 17, 2008 at 11:03 am
Aveerabadran are you sure that the column data type is timestamp. and not a datetime data type.
From BOL
Is a data type that exposes automatically generated, unique binary numbers within...
July 17, 2008 at 9:54 am
You should take into consideration the danger of using dynamic SQL statements, in that they provide a path through database security for injection attacks, and unauthorized data access.
July 17, 2008 at 8:03 am
Viewing 15 posts - 2,986 through 3,000 (of 3,221 total)