When I try to run this script I get the 'invalid column name error. Can anyone tell me what I need to do to correct the error? SELECT PROVIDER.PROV_PATH, INSAGRE.PROV_ID, PROVIDER.NAME, INSEMPL.EMP_MO, INSEMPL.EMP_YR, INSEMPL.EMP_CNT, CAST(cast([EMP_MO] as varchar) + '/1...more >>

Hi! I have a following questions: 1. We bought Standard SQL licence per CPU but had to switch to licence per seat( to use transactional replication). What exactly is per seat, We have 30 persons who are connecting to SQL server, 15 scheduled jobs running localy on the server. Online replic...more >>

What is the measure of the DiskIO values reported when one runs sp_who2. ? ...more >>

Hi, Have a question, I have a select query that I used for bcp out one of my MS SQL 2000 DB table ( about 30 million of records) and it take more than 3 hrs to finish(about 13 million record). It happen that when this bcp process is running no record can be inserted to this table. Isn't th...more >>

Hi there. This is not my 1st post related with performance. I am experiencing serious performance problems with a VB6 application running over a SQL Server 2000 database. I have already used SQL Analyser, SQL Profiler and Performance Monitor to collect data that might help resolve this prob...more >>

Hi, We have a program the connects to the SQL 2000 database (Server A) and the program runs on Windows Server 2003 Terminal Services (Server B), the issue that we are having is that multiple process ID have been created (in our case its 4 process ID) whenever the program connects to the da...more >>

Hello, I am working with SQL Server 2000 and their are clients constantly adding, removing and updating records on a daily basis. What I am looking for is a way to make a querry of all the changes made for a particular day or time frame. Is there a way to accomplish this? Thanks, ...more >>

I had to make some changes recently to the account that my Agent runs in. Now, my scheduled jobs dont run. Its not that they run and fail, they just dont run. If I manually start them in Query Analyzer in the account that the Agent runs in, I get the message saying : "Job 't_t_t_t_t_Pseudo' st...more >>

Hello all We have data that we import using access import specs in to Access. But the data is getting rather large and we would like to switch to our SQL database and analyze the data there. Is there any way to use the access specs in SQl server and import the data using bulk insert or bcp. We...more >>

Hi there, I was following an HOW TO article from Microsoft's KB (ID: 224587) related with SQL profiler. Once SQL Profiler is opened, they say to click Tools under menu Options and then make sure that 'All Event Classes' and 'All Data Columns' options are checked. Well, I cannot find thi...more >>

Hi, We have sql7 with sp4. Need to know how do I check our dbs are page level or record level locking> Thanks in advance ...more >>

Hi, When I modifiy the properties of a SQL Server Login, I get the "Confirm Password" screen displayed. This is displayed even if no change is made to the login. Is this a bug and is there a hot fix out there. Just want to know if anyone else has had this problem. -- Thank You for y...more >>

Hi, Does anyone know of an obvious reason for indexes to get corrupt or have the statistics get really out of wack?? We had a problem today where the performance just went down the toilet.. It was really obvious that a particular frequent query was taking 1000 times longer than norm...more >>

Hi Has microsoft announced any date as to when it would stop the support for SQL Server 7.0 Thanks...more >>

Hi, The method to transfer the logins with the password from SQL Server 6.5 to SQL Server 2000 is to upgrade the databases using "upgrade wizard". There is no documented way to move logins with password using scripts. But there is undocumented method method to do this. see the below link. ...more >>

I really need some solid advice here. I am a DBA and do not do any programming in .NET however my developers I work with are pressing me to do something that feels wrong and I cannot put my finger on it. They are telling me that they need access to the TempDB because the .NET applications ...more >>

I am experience a very strange performance problem. A nightly job that had been consistently running 2 hours each night is suddenly running 16 hours. A trace reveals a section of code taking 2500-3800 milliseconds of CPU to process. The execution plan for the select statement shows the indexes ...more >>

SQL 2K I ran the below sql to list the table name and column_name with column_name like 'ID' select substring(so.name,1,50) 'Table Name', substring(sc.name,1,50) 'Field Name' from sysobjects so inner join syscolumns sc on so.id = sc.id where so.type = 'U' and sc.name like '%ID%' order...more >>

Is there any way I an view triggers in SQL 2000? ...more >>

hi , I want to migrate from sql 7 to sql 2000 and now my issuse is that double quotes are not suported in sql 2000 and they where suported in sql 7 . an many of my procedures are using it .what should i do . -- Message posted via http://www.sqlmonster.com...more >>

I'm somewhat new to this but last week I created a sp that goes and gets about 200+ records about 30 times and performs some simple calculations and dumps the data from the table variable to the screen. This is in query analyzer btw. To do this I 1. find out how many test samples I have...more >>

The documentation talks about default values, but gives no examples. I'm trying to get this to work... ALTER FUNCTION FirstDayOfYear(@date datetime = getdate) RETURNS datetime BEGIN RETURN convert(datetime, '1/1/' + convert(varchar, YEAR(@date))) END They say you need to pass in "default...more >>

Ok, folks, I got one for you. I want to allow a user to make schema changes to tables in a database that are owned by dbo. However, I do not want this user to do anything beyond that, such as add roles or change permissions on objects, etc. It appears that the db_ddladmin fixed database role o...more >>

If restore a backup of a database to a database with a different name and owner, do I have to recreate the views and re-apply permissions to the tables etc. As I far as I can see all the views are owned by the dbo, but the actual database owner differs. From a SQL Server point of view I can lo...more >>

HI I have tables with 4 years data with NO DATA COLUMN . Is there any way to find out, what is space used by table for given year (say 2003) or is there any way to find number rows inserted/update for given year (say 2003) thanks Kalyan...more >>

I have a question regarding database design and size . I am migrating from several DB2 databases to SQL server. I was going to create different databases based on application dept or business units (the way it has been in db2). But my application folks says, they cannot connect to multiple datab...more >>

Hi there, I have a VB6 application working over a SQL Server 2000 database. since a long time ago, I am experiencing serious performance problems, that I still can't resolve. Normaly, the performance problems are related with database design, query design, application design an hardware. Th...more >>

I moved (a couple of nights ago) my master database from one drive to the other. When I do sp_helpfile, it shows up correctly on the new drive. But when I do select name, filename from sysdatabases where name = 'master' it shows the old drive location under filename. Is this a pro...more >>

We have winxp workstations with a client software that connects to a win2k3 server with sql 2k & sp3 installed to access a medical database where we pull up the patients information. About a week ago 2 of the stations became slower then normal when searching information from the database caus...more >>

I couldn't get the field titles on the Excel and for the datetime field it only shows time not date & time. Thanks ...more >>

Is there a way to run a query or a function that will return every Saturday of the specified year in mm/dd/yyyy format? TIA, Vic...more >>

Is the only way to store unicode characters through changing char and varchar datatypes to nchar and nvarchar, or can you change it through a database or server setting or collation? Thanks in advance, Paul...more >>

OK, I create a table called Customer, I imported date from my as400, when i want to set a primary key it telling me that i have duplicate key. Keep in mind the layout of my table CustId, SubCustId, in CustId they can have more then one same CustId, but SubCustID have not the same SubCustID. ...more >>

Hi What do you think about MSSQLRecovery 2.0, to recorver suspect database. Do you know a better software to recover suspect database. Best regards Hervé RESCOURIO ...more >>

Hi, I need to enforce that a table does not have "duplicates" for a specific status type in the table. If the column "STATUS" = 2, then there can not be more than one row with a specific "ID" column. I can not use a unique key constraint because duplicate values for this combo of columns...more >>

I use the database maintenance plan to do my backups, I take all the defaults and this works well for me but one system will not make a backup. Under jobs all jobs fail but the database maintenance plan history is empty. the plan name, server name and database name drop down boxes show all but...more >>

I'm trying to do a len() function on a text field in SQl Server 2000. Of course this doesn't work but is there a another way to do this? Thanks, Ben Bleser...more >>

Hi I want to know what is the last stored procedure executed in the server and by which user. Is it possible to find. (I think there is some log for this) anybody can help me. Advanced Thanks B. Sundar...more >>

Our Page file seems to be growing out of control. We have a SQL Server 2000 64-bit on an Itanium system w/ 8 GB of RAM. when we start/re-start the service, the page file is a reasonable size (1 to 1.5 times RAM). After this the page file grows by 0.25 GB per hour. PerfMon says that SqlServer...more >>

I am testing SQL Server 2005. I tried to uninstall Beta2 and ended up having issues. Now, I cannot get the setup to run to do reinstall. Okay, the uninstall didn't work. How can I get machine XP Pro cleaned Up and get the product reinstall? Do I have to reinstall the OS and Reformat my disk dr...more >>

I have found this article: Dynamic Backups SQL Server 7.0's backup process is faster than SQL Server 6.5's process. Let's look at how these two processes differ. When SQL Server begins a backup, it notes the Log Sequence Number (LSN) of the oldest active transaction and performs a checkpoint...more >>

I hope someone can help with this, at the moment I'm maunually running the stored procedure sp_cleandoneinstances to clear down our Biztalk xlang database on a daily basis. Now my problem is not enough hours in the day, as I'm sure most of you will appreciate, so I want to automate this sp. ...more >>

Hi, Can someone tell what different with Standard Edition and Enterprise Edition. I knew those prices different. In our production Internet and Intranet need install SQL Server 2000, I just want know if I need do replication for those databases located in this server to secondary site, w...more >>

Hi, 1) How do we specify constant values in BCP Format File? ex FileABC --- CONSTANT 1044035814. 2) How do we map one Value to TWO column fields in BCP Format File. ex -- Data file Value --- "123 ABCDE" Filed1 -- 123 ------ Filed 2.. I want the value to be "AB" Field 3.. I wan...more >>

Hello, I want to capture the texual form of execution plan when using the perfmon utility. From what 've read I need to select the "Performance: Execution Plan". Am unable to find this particluar entry. All the other SQLServer related entries (from 'Access Methods' to 'User Settable') appear ...more >>

Hi We have a plan to migrate from SQL Server Agent to Control for job scheduling. For those who have done this or attempted to it, I would be very grateful if you could share some of your experience. I would be interested in: - Which scripting language did you use for wrapper scripts? -...more >>

I have a System that has 2 Instances of SQL and I need to move a database from one to another. I will like the Users/Logins relating to this database to be intact and automatically move to the corresponding folders "Instance/Databases/DatabaseName/users" and "Instance/Security/Logins" in the ...more >>

I am backing up databases on SQL Server 2000 using a Database BackUp Plan. I have set it to delete files older than 1 day. This used to work, but now just backs up without deleting the old files. Any help would be appreciated, Craig...more >>

Hi, I have the SQL Server Agent service and SQL Server services running under user 'A'. I am logged on as user 'B'. I wish to schedule some processes to run using SQL Server Agent; backups, data manipulation, etc. One of the processes (call it 'P') is an inhouse application that runs, sho...more >>

SQL Server 2000, Windows 2003 server on a Dell 2650 w/ 5 disks and RAID. Should I make: 1. single RAID 0+1 container w/one hot spare 4 partitions: OS, DATA, Pagefile, logfiles. 2. two RAID 1 containers w/hot spare for one of them OS and DAta on one, logfiles and pagefie on the other? 3. ...more >>