Using VB Dlls for Extended Stored Procedures
Can this be done? Urgently need an answer to this a simple Yes or No would suffice.
2001-11-07
1 reads
security
Worst Practices - Assigning Users Rights
Continuing with Andy Warren's series on Worst Practices for a DBA, Steve Jones joins in this week with his worst practice.
2001-11-06
7,233 reads
migrating SQL Server 6.5 to 2000
Hello, I need the steps to migrate a database from 6.5 to 2000. I tried different ways as: 1. DTS but I can´t find DTS on 6.5 2. I don't have problems to migrate the structure of the database but when I wnat to migrate the data with BCP I can´t find the way to […]
2001-11-02
54 reads
Top 100 things you don't want the sysadmin to say
Comments posted to this topic are about the content posted at http://qa.sqlservercentral.com/columnists/sjones/funny43.asp
2001-11-02
2 reads
Executing stored procedure connected on Oracle
I created a stored procedure as follows: CREATE PROCEDURE ImportsPROJECTS AS delete from SAP_PROJECTS insert into SAP_PROJECTS ( PROJ_TYPE, PROJ_PSP_ID, LIB_PROJ, CLI_NUM ) values ( '*', '*All*', '*All*', '*All*' ) insert into SAP_PROJECTS ( PROJ_TYPE, PROJ_PSP_ID, LIB_PROJ, CLI_NUM ) SELECT PROJ_TYPE, PROJ_PSP_ID, LIB_PROJ, CLI_NUM FROM OPENROWSET( 'MSDAORA', 't30.world';'HRUSER';'HUMRES', 'Select PROJ_TYPE, PROJ_PSP_ID, LIB_PROJ, CLI_NUM from sapr3.PROJECTS') […]
2001-10-30
Allowing BULK INSERT for non-SysAdmin Users in SQL 7.0
One of the largest security "issues" in SQL Server 7.0 is that a user must be in the SysAdmin role to run the BULK INSERT command. This article by Paul Ibison shows you a workaround.
2001-10-30
6,113 reads
Executing a Stored Procedure from a DTS
Executing a Stored Procedure from a DTS package is very simple while working with a "Execute SQL Task". I would be very glad if anyone could tell me a good way of using Stored Procedures in transformations tasks such as "Data Driven" or "Transform Data Task".
2001-10-29
connection error
Hi,i'm using sql server 7 (desktop edition)on windows me and windows-98 m/c.using enterprise manager i want to connect this two servers,i'm getting general network error ,stating connection already open,anybody help me pls. sakthi
2001-10-26
3 reads
Connection Failure
Hi, This is urgent. I get a new connection Failure from my system while connecting thru QA or anything else. Does anyone know what I need to reset. This was working fine till yesterday Error is Connection Failed: SQLState:'01000' SQL Server Error:20 [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen(PreLoginHandshake()). Connection Failed: SQLState:'08001' SQL Server Error:20 [Microsoft][ODBC SQL […]
2001-10-25
7 reads
Recordset from stored prc using OpenQuery
I want to have the recordset from a stored procedure. I am using the following query select * from openquery(server2 , 'server2.esop_softdel.dbo.sp_sel_summary @EmployeeID="0000000001", @CompanyID="0000000001"') My stored procedure is using a temp. table #sumarry. If i execute the above query I am getting the following err: I am not able to find out what the error […]
2001-10-25
2 reads
Blogs
Simple Talks Episode 7
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
A New Word: the McFly effect
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
Key mappings in Visual Studio Code
At a recent conference I was asked how I executed code during my presentation....
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers