I want to be able to execute informix stored procedures from an MSQL 7.0 server, via a linked server connection. I have the informix server available on the MSQL 7.0 server like a linked server, but I can see only the tables.I'm using the Microsoft OLE DB provider for ODBC and a system DSN with […]
2001-08-08
4 reads
Hi all Ive found recently that the transaction log file for a database will NOT extend (even though auto extend is enabled) when a single transaction that is running hits the end of the log. I mistakenly thought that SQL*Server will extend the log when a space request failed. But if its the only transaction […]
2001-08-02
6 reads
Hi all, I'm a newbie SQL admin. I understand that the 1433 port is vulnerable. So, I plan to change it. What should be done for me to make sqlserver work fine with another port? What should be done in theproxy server side and the SQL Server side. There is another guy to take care […]
2001-07-30
Hi all, What is the backup file format for a full-backup. When I give a filename for backing up using the backup wizard, should I give an extension like .bak etc. Because, I found that the backup which I make, has no extension. Kindly clarify Cheers Parasu Parasu Raman
2001-07-27
3 reads
How can I load test a database? Is there a tool that can simulate thousands of transactions at once? I want to see the effects on replication.
2001-07-18
2 reads
Before I start Im a novice SQL user. I have instlled MSDE which is a cut down version of SQL 7.0 I have installed SP3. I have created a DB Projectsql, I have created a role called "Project" I have added two NT users DOMAIN\Barbie and DOMAIN\Ken to the role 'Project'. I have granted the […]
2001-07-17
2 reads
I am trying to configure a linked server to a local Access database with no security and only one table. I set it up and tested on a test machine first and all works fine. I then did the same on our production box and receive the error below. Server: Msg 7303, Level 16, State […]
2001-07-16
6 reads
What is the optimum number of columns that can be grouped by in SQL Server 2000 ?
2001-07-13
2 reads
hi, i have the following query problem: let's assume that there are two tables (a and b). table a contains two fields (f1 and f2) which contain unique ids pointing to table b. table b contains the details to a.f1 and a.f2. is there a possiblility to retrieve the detailed data from table b with […]
2001-07-13
5 reads
Hello.. I was trying to write a stored procedure that could execute another row-returning stored procedure and apply a where and order by clause to be used with some components I wrote. I'm probably not explaining myself properly, but I imagine that the stored procedure would look something like: ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ CREATE procedure sp_execute_sp ( @procedure_name […]
2001-07-09
3 reads
By Rob Sewell
Whether you’re a developer at an agency or an aspiring creator, you can trust...
“Could you help me, we deleted the database’s transaction log file and now that...
I had a couple of clients who were moving content from development catalogs to...
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