Viewing 15 posts - 1 through 15 (of 19 total)
You can find information about ghost cleanup on sql server tips and tricks section.
When you delete a record from any table in SQL Server, SQL Server doesn't actually delete these...
October 7, 2003 at 2:44 am
Use IN operator
Create Table xXx
( Field1 vachar(10), Field2 varchar(10),
Check ( Field1 IN ('C', 'X', 'B', 'R') And
Field2 <>...
March 26, 2003 at 11:45 pm
You better use an OLE DB Provider that supplied with your Oracle Client CD ROM. The OLE DB Provider that supplied by Microsoft cannot use for some version of Oracle,...
March 26, 2003 at 9:18 pm
It's true that you can install SQL Server and AS in one box. But remember not to install AS and VS .NET in one box. It's never work with me,...
March 19, 2003 at 2:55 am
You cannot use CAST function with datetime data type in Indexed View.
It seem you have a problem while you are loading your fact table. Post the script that you...
March 19, 2003 at 2:42 am
What conditions whould you use? Is the conditions a column from one table. If YES use user defined function
Hendra
March 19, 2003 at 2:21 am
There is a difference between user concept in Oracle and SQL Server. In Oracle, you create a user on specific tablespace, then grant that user some privilege. In SQL Server,...
March 19, 2003 at 2:16 am
Yes, you can move database file. But remember, you cannot rename your logical database file.
March 16, 2003 at 9:48 pm
There are 3 main reasons why I choose SS:
1. VB is really really a great programming language, but Developer 2000 is sucks. We all want to deploy...
March 16, 2003 at 9:47 pm
That was an error from ddrk_setup.log. FYI, it's fine with ddrk 2.2. I gave administrators credential to internet user, but it still raised the same error message.
BTW, thanks for...
March 12, 2003 at 10:36 pm
Try this one
Select *
From
( SELECT CASE
WHEN type = 'popular_comp' THEN 'Popular Computing'
WHEN type = 'mod_cook' THEN 'Modern Cooking'
WHEN type = 'business' THEN 'Business'
WHEN type = 'psychology' THEN...
March 4, 2003 at 7:36 pm
Try this one
Select *
From
( SELECT CASE
WHEN type = 'popular_comp' THEN 'Popular Computing'
WHEN type = 'mod_cook' THEN 'Modern Cooking'
WHEN type = 'business' THEN 'Business'
WHEN type = 'psychology' THEN...
March 4, 2003 at 7:36 pm
Nothing, I just wondering wether i could implementing a real time data transfer
Right now I'm using DTS to transfer the data between this two servers.
March 13, 2002 at 10:43 pm
You really really a dba if you receive a phone call telling you they got a problem as much as a telephone operator
March 12, 2002 at 11:09 pm
This is an error message
Error 7399 : OLEDB Provider MSDAORA reported an error
Do I have to use MSDAORA.1 instead of MSDAORA in a linked server defenition ?
February 25, 2002 at 8:10 pm
Viewing 15 posts - 1 through 15 (of 19 total)