quote: I have already written hundreds of low level DB staff in C, C++ (using dblib and ODBC) but not in Delphi. and you can't think of using C this time. Well, I think you should use ADO in Delphi. Doesn't speed up things, though, I guess. Are you doing this at regular intervals with […]
2003-08-12
1 reads
Hi Andy, quote: We've got a beta feed you can try: http://qa.sqlservercentral.com/sscrss.xml not sure, if it is intentionally if I should see the XML code. Must I change some settings? quote: Not sure if Brian will see this for a day or two, we're all meeting in Orlando on Thursday. Does this mean he is […]
2003-08-12
1 reads
Hi Buell, I think, although your question seems to be answered, if your statement needs to be run dynamically you might want to consider NOT to use EXEC @query, but rather EXEC sp_executesql @query. Not only that Microsoft prefer this over EXECUTE, but you'll get a higher probability that execution plans can be reused. However, […]
2003-08-12
2003-08-11
1 reads
Make sure the server authentication is not Windows Only. Right click on the SQL Server in Enterprise Manager, select Properties. On the Security tab, check that Authentication is not Windows Only. -- And please, I hope this is not a production box!!! Never use sa no password...
2003-08-11
I like the idea behind WITH UPDATEEXISTING. I feel it needs three settings. ON - Does what it says on the tin. OFF - Performs INSERTS only but throws errors if primary keys are violated. IGNORE - Performs INSERTS only but does not process duplicated primary key and therefore does not need to throw key […]
2003-08-11
Hi your mean something like this below, where @p_dbname is a parameter to the stored proc. set @Nsqlstring = ' select @vfileid = fileid, @vtotalpages = size - 1 from ' + @p_dbname + '..sysfiles where fileid = ' + cast(@p_fileid as varchar) EXEC sp_executesql @Nsqlstring, N'@vfileid integer OUTPUT, @vtotalpages integer OUTPUT', @fileid OUTPUT, @totalpages […]
2003-08-10
1 reads
Stinkin' SMTP server was hung. All fixed now. Thanks! Brian Knight bknight@sqlservercentral.com http://qa.sqlservercentral.com/columnists/bknight
2003-08-08
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2003-08-08
Hi Tom, quote: This should do for you. Microsoft Knowledge Base Article - 106122 sp_fixindex. can you provide the full link? Cheers, Frank
2003-08-08
1 reads
By Steve Jones
I’m leaving again tomorrow for a trip. This time I head back to Boston...
By Tim Mitchell
Most of us who work with data have, at least a few times, been...
By Rob Sewell
The Social Web Foundation is aiming to grow the fediverse and make the social...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers