hello to the expert,
pls advise, how to add & edit record with SP using vba?
DBcn.SP_LoadGenRouts parm1, parm2, rst
if not rst.eof then
rst!field1=x1
rst.update
else
rst.addnew
...
I'm trying to run a .NET Dll under SQL Server 2005.
I work fine but the DLL is running under the LocalSYSTEM account.
My DLL is accessing the network data
It work only if I change the acco...
I have the following data:
status item cost
4 Fee1 $25
8 Fee2 $50
16 ...
I'm looking for documentation as to install and configure database mail for SQL 2005.
I cant connect to my database using sql authentication in MSSMSE. i have sql express2005
i set up a login and typed in a login and password for sql authentication under security
i get s...
Hi,
Frequently we create various lookup tables in our databases to store what one might call "reference" data. For example, a list of industries, a list of employment types, a list of stat...
Hello,
As part of our NHS entitlement (National Health Service for non UK residents) we are entitled to use ForeFront free of charge. From everything i've read it rates much higher than mos...
I am currently looking into using SQL Server 2005 Reporting Services to perform reporting tasks for an ASP.Net web application. The web application itself uses forms authentication to restrict...
Im no expert when it comes to SQL not by any stretch of the imagination.
But Ive being tasked with SECURING a web server in a dmz with 2005 SQL on it.
Set up is
2003 R2 SP2 Server standar...
everytime I launch the import or export task for SQL 2005 and transfer a database from one locatio to another, I lose all primary keys and Identity settings and have to go through each and eve...
Hi Experts,
I have created a package(SSIS) with multiple Data Flow Tasks, I run this package through the SQL Server Agent everyday. Today the package failed after 4min at a Data Flow Task t...
I have attached 2 files.
One contains a sample of some table data. The other contains the desired query output based on the sample data.
Basically, that table has 3 columns name, call d...
I have a job that is scheduled to run on a SQL2000 server running on Windows 2003 Server SP1 and it is connecting to 2003 x64 SP2 machine that is running SQL 2005. When cross server stuff hap...
I recently upgrade a server from SQL2000 to 2005 64 bit... I need to perform some manipulation using regular expressions in some of my procs.
I have previously used http://www.codeproject.c...
My company uses an ERP system that is totally wrapped around a SQL Database. All functions are tied to stored procedures and such which makes the database not only an information store, but a...
Is it safe to place indexing on a live production database without shutting it down first? I have a client that has a table, and I need to place indexing on two columns as they are searched u...
An EE genius figured out this script below to find injected junk in my SQL Server DB. I'd like to take it a step further and perform an action if some junk is found. Can this run in a DTS pa...
First, there currently is no DBA, just this lowly Systems Admin and I'm not very familiar with this environment. Telling the story because some of you will probably get a good laugh ;)
I h...
Hi Experts,
We have an IMClient that communicates with the product server and sends status messages to the users like job completion message and jonb transfer message. The IMClient is part of...
I'm trying to setup email alerts via SQL's maintenance wizard... I have everything setup except the Outlook profile.. I don't have Outlook on the server, however, I do have a SMTP server I ca...
Hi.
What I want to do is pretty simple.
I have an SSIS package.. with an Execute SQL task.
Basically I want to restore last night's backup to another server, then do stuff on that another...
Hello Experts.
It is simple to issue a "Grant Create table to sqlUserName"
Or "Reovoke Create View from JhonDoe"
The question is. How do I know what permissions are active for a given u...
Scenario:
GoDaddy Window 2003 Virtual Server with 512 mb ram.
Apache 2.x using ISAPI dll.
Backend Database is SqlServer 2005 Express.
About once a week SQL Server will get a "The availab...
I configured a new server with windows 2K3 standard R2 with updated .net and installed SQL server 2005 dev edition. I am duplicating everything from a previous server running identical softwar...
I want to sort out put in the following way
Prod A Cust_1
Prod A Cust_2
Prod C Cust_1
Prod C Cust_2
Prod B Cust_1
Prod B Cust_2
is there a way to sort entries forcebly (e.g. Prod ...
