Recent content by Bernadette

Hi There A login allows a user to connect to the SQL Server it DOES NOT allow the users permissions to any of the databases. The logins is then mapped to a User. The user can then access the database you give them permissions to. If you want the user to do anything with the database you must...

Hi There There is an option in the database properties "Select Into/BulkCopy". If this is checked you can perform non-logged operations. Has someone ran a non-logged BCP (or similar) or SELECT INTO operation. Does someone turn this option on, do the operation and then turn it off ...

Hi There I have no problems with SP4 on any of our production servers. The only problem I ran into was installing Microsoft Content Management Server. I had to patch the SQL Server, patch it to SP3, Install CMS and then patch it to SP4 as Microsoft CMS did not recognise SQL versions above...

Hi Tom, There is a copy of the install script for the Pubs Database in your install folder on your server. <SQL Install Dir>\Install\instpubs.sql If you run this script in Query Analyser you will create a new pubs database however be sure to drop the existing one if it exists. DROP DATABASE...

HI Seosamh, You will have to use SQLDMO to do this. Try the following from the following url http://www.swynk.com/friends/warren/dmotrigger.asp .... Enable Trigger --------------- Dim oServer Dim oTable Dim oTrigger dim DBName 'change this to your database name DBName=&quot;PUBS&quot; Set...

Hi There Outlook Express (OE5) installs a simple MAPI messaging subsystem and does not provide the mechanism for creating a mail profile, you cannot use it with SQL Mail as SQL Mail uses Extended MAPI. Check out the following url ...

Hi There Check your MDAC version. Ver2.6 always tries to use NT Authentication. (hense SSPI errors) Try using another MDAC version. Version 2.7 has support for XP (I am nearly sure). I know that they fixed the problem in ver 2.6 sp1. Bernadette

Hi There This will return the last day of the month for you. It uses GetDate() to get todays date to get the current month Declare @mydate datetime Set @mydate = '<insert your date here>' SELECT DATEADD(day, -1, DATEADD(month, 1, DATEADD(day, (1-DATEPART(day,@mydate)), @mydate)))...

Hi There Has the user who is running the stored procedure got access to the &quot;BB4INLINESAMPLES&quot; database and the &quot;dbo get_lotno&quot; stored procedure ? Bernadette

Please post a copy of your code so we can have a look. Bernadette

HI There It sounds as if one of your tables is corrupt. You may need to restore the database from a backup. Hope This Helps Bernadette

Hi There Check that the version of the file REPODBC.DLL in C:\Program Files\Common Files\Microsoft\Shared\Repostry is version 2000.0.xxxx.0, This version is for SQL Server 2000 and Repository 3.0. If you have the wrong version you can copy the file from SQL Server 2000 Setup CD and...

Hi There You will need to use an actual Windows NT account for SQLServerAgent to use DTS. Chhange your SQLServerAgent acocunt to run under an NT Account with Local Admin and Domain User rights. The LocalSystem account has full privelegdes on the local machine, but, has no priveledges...

Hi There, The tables you are looking for are in the msdb database. They are ... msdb..sysdbmaintplans msdb..sysdbmaintplan_jobs msdb..sysdbmaintplans_databases msdb..sysdbmaintplans_history Hope this helps [3eyes] Bernadette

Hi There The recommended and best thing to do when you are upgrading a database is to use the Database Upgrade wizard. This will transfer the whole database including the data. However if you really want to, you can use DTS to transfer the data from the SQL6.5 server to the SQL2000 server...