Viewing 15 posts - 13,411 through 13,425 (of 13,463 total)
the error you received is because child records exist which are not in the parent/referenced table;
run this query:
SELECT CLINICPHONE AS MISSINGCLINICPHONE,* FROM DBO.CENTER WHERE CLINICPHONE IS NOT NULL AND CLINICPHONE...
April 27, 2005 at 9:21 am
I don't think the time to run DBCC CHECKDB is a function of the size of the database only, but rather a combination of something like
(number of tables) *...
April 21, 2005 at 7:37 am
On my dev box I had sql7 as the default instance , and SQl 2000 and SQL 2005 as named instances;
from the SQL standpoint I had no problem, and all...
April 19, 2005 at 7:02 am
I think that due to foreign key constraints, a cursor is not the right solution.
i would recommend adapting the Hierarchy2 script from this site.
http://www.sqlservercentral.com/scripts/contributions/759.asp
it returns all tables in the...
April 19, 2005 at 6:41 am
Another text editor with syntax highlighting, which also prints in color is EditPlus http://www.editplus.com
April 7, 2005 at 12:23 pm
another pointer...you should never have a trigger actually send an email; it can take several seconds for the email step to occur, and if there is a network or other...
April 7, 2005 at 6:40 am
offhand, i'd bet a buck on the second sql statement, which inserts into delivery_detail.
i'd say change the 3 LEFT JOIN's to LEFT OUTER JOIN's
if the join for those 5...
March 28, 2005 at 1:02 pm
Found it myself;
Query Analyzer uses the dll sqllex.dll for the definitions of keywords.
i did the old regsvr32 "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\sqllex.dll"
and it fixed the issue; hope that helps someone else...
March 25, 2005 at 10:00 am
Are you sure the data is being deleted, or is there an error in the code and the details never get saved in the first place?
you could grab some of...
March 25, 2005 at 6:21 am
couldn't you create a view of the table that has the results of the udf as additional columns of the table/view?
for example create view vw_sometable as
select col1,..colN,dbo.fn__special1(col5) as Result1,dbo.fn__special2 (col5,col6)...
March 22, 2005 at 7:04 am
the semicolon is also recognized as a command separator, if that helps.
March 18, 2005 at 5:49 am
i would bet that a connection string is incorrect when it is moved to production...
I don't know your app of course, but if the connections string is hardcoded to look...
March 16, 2005 at 1:08 pm
I typically see this when an ADODB connection has not been opened, and then you try to open a recordset with the still closed connection;
for example:
dim conn As New ADODB.Connection
conn...
March 16, 2005 at 6:09 am
As far as I know, the ONLY way to save your xml is using an application stream for SQL 2000. SQL 2005, with it's more robust XML support, may offer...
March 8, 2005 at 6:31 am
apparently a hind_ can be either a hypothetical index or a hypotehetical statistic; note how the tweak the dynamic sql based on the objectproperty:
from the same MS KB article:
DECLARE @strSQL...
March 2, 2005 at 3:28 pm
Viewing 15 posts - 13,411 through 13,425 (of 13,463 total)