I'm not sure there is a good way to do this. My guess is that only your documentation would cover this. Steve Jones sjones@sqlservercentral.com http://qa.sqlservercentral.com/columnists/sjones The Best of SQL Server Central.com 2002 - http://qa.sqlservercentral.com/bestof/ www.dkranch.net
2003-12-31
2003-12-22
1 reads
I haven't, but I have worked with SQL Anywhere. There's no reason why they shouldn't be able to coexist. I wouldn't do it, just because I don't like to install anything else on a SQL Server server, but I suppose sometimes it is unavoidable.
2003-12-11
1 reads
When I started programming SQL Server stored procedures, I also did not use the autoincrement feature. So I created a stored procedure nextvalue which returned a new ID. Everytime I wanted to insert a record I coded EXECUTE nextvalue @NewID OUTPUT. Using a SQL statement like INSERT INTO table_x SELECT col1,col2 FROM ... was impossible. […]
2003-12-04
There must be a conflict between the tables constraints. A check constraint is overlapping between base tables. That is the only thing that could cause this type of action. If you could send me a script of your base tables with views definition, I will be glad to find the problem. tommy.brickle@stratapult.com
2003-11-18
2003-11-13
1 reads
Another use is for searching the contents of MS Office documents (and pdf with free plugin) that are stored in the database.
2003-11-13
1 reads
If you can create stored procedures in the Progress database, I think you can configure the linked server to be read-only. There are two parameters in the sp_serveroption procedure that might accomplish this: data access Enables and disables a linked server for distributed query access. rpc out Enables RPC to the given server. If you […]
2003-09-04
1 reads
Unfortunately we've just wasted three months trying to tie down things at the other end. Let's just say that negotiations were not very fruitful Hope this helps Phill Carter -------------------- Colt 45 - the original point and click interface
2003-09-03
I think you have to do the work one way or another. Perhaps in the next version of SQL...! Andy http://qa.sqlservercentral.com/columnists/awarren/
2003-09-03
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
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