Have good grasp of mdb's. Beginner with sql Have sql db of charity organisations with contact details, all fairly simple. Have one Field for web addresses entered www.xxxxx.co.uk another for emails entered aaaa@bbbb. Unable to work out how to make these active. Its certainly not like mdb's!...more >>

Hi All, I'm hoping someone can help me. I think I'm missing something very basic. I'm trying to put a clustered index on a view that I have created. I keep getting the error: Server: Msg 8668, Level 16, State 1, Line 1 An index cannot be created on the view 'cew_avwage_uscnty' because th...more >>

SELECT TOP 100 w.TimeDate AS [date], p.ProdCode, COUNT(w.BoxID) AS cases, AVG(w.PrintedWeight / w.PkgsPerBox) AS avgtrayweight FROM dbo.WIPSixtyDay w INNER JOIN dbo.Products p ON w.PLUNo = p.PLUNo WHERE (p.PrePack = 1) AND (w.PkgsPerBox > 0) GROUP BY w.Time...more >>

I am running SQL Server Best Practices on a SQL 2000 database and it is recommending me to change the temp tables inside SPs to table variables. I had read already in other places to use table variables over temp tables. I also know I can't create indexes as I can on temp tables. Instead I'll...more >>

Can someone explain to me why the following doesn't work? declare @oname sysname select @oname=name from sysobjects where name like "df__mytable__mycol%" alter table mytable drop constraint @oname ...more >>

Here is an obscure question that I am sure can be dealt with from a 10,000 ft view: I have installed Fuego (an enterprise level BPM). Another application was built in-house to connect to Fuego (Fuego has two SQL 2000 databases to handle the business process flow and instance flow). This in-ho...more >>

I am looking at a table in Microsoft SQL Server. I went to th dependencies of this table and it says TRIG_customer. so i a thinking there is a trigger that affects the table but how do i se what is the code that resides within this trigger. I looked among th stored procedures but i couldnt find ...more >>

Dear All, I am using the oracle transparent gateway connectivity with sql server using tg4msql,as far as settings are concerned those were set and Connectivity is working Fine, and getting the response from that server. here is description what I done as:-There is a View on Sqlserver which...more >>

Please pardon my ignorance, but I am using MS SQL2000...On system start up the Server Service Manager defaults to server "BACK" which is not even registered in the SQL Enterprise Manager. Enterprise Manager shows only one server " OFFICE" which is the one I want to default to. How do I remove the...more >>

Hi, all: I have been tasked with determining how many licenses of a certain SQL Server 2000-based application are actually in use: in other words, record or log connections made to the database by clients. Client connections will be made with a generic SQL Server ID which has been granted a...more >>

Hi All!! I need to build small phone book db. There are phone numbers and name (to whom phone belong) There are distribution lists that holds phone numbers and also can hold another lists. There are Users to whom distribution lists and or phones belong. Any ideas ????? TNX -- ...more >>

Hi, When I drop a table in Sqlserver 2000 database, The following error occurs: Server: Msg 1204, Level 19, State 1, Line 1 The SQL Server cannot obtain a LOCK resource at this time. Rerun your statement when there are fewer active users or ask the system administrator to check the SQL Server...more >>

I am trying to get a total for times, but I am having trouble getting anything to work. Basically I created a query to pull up several people's name that performed certain details and how long each detail was. I now want to add up all the hours to a total for each person. Can anyone point me i...more >>

Hi I downloaded MSDE2005 and I tried to set up an ODBC connection to a database I created. I can see the database using client but I got this error through the ODBC manager [Microsoft][SQL Native Client]An error has occurred while establishing a connection to the server. When connecting ...more >>

Hi all! What is the best tool to use in order to get some SQL performance logs? I could use build in admin tool perfmon but I was wondering whether there is a way I could anaylse the write a report on the performance using EM ? Thank you in advance! ...more >>

Friends, I would just like to know that why SQL Server doen't allow us to define a text data type local variable while creating trigger? I tried creating a text variable in a trigger as a local variable and it raises error. "Implicit conversion from data type text to nvarchar is not allow...more >>

hi. coming from postgresql, i am used to textual references to most of the things i do with the database. i feel a little lost with all the graphical. i have few questions regarding MS SQL 2000 1. what is the best (or easiest) way of getting a table definition in text? it could be either a C...more >>

Hi, I have(had) an old Win2k Server server with about 30 web site databases (SQL 2000) that just went under due to hardware problems. Thankfully, I have backups of all the databases plus the MDF and LDF files from the hard drive. I want to move all of these sites and their data to a newe...more >>

I've seen several posts that begin to address this problem, but have not found a simple, elegant solution that will accomplish this goal. The important part of this solution is that it must be completely dynamic - I have over 40 different categories of devices, each with different fields, and ea...more >>

I am an old guy that comes from the large IBM 370 generation, at that time was very easy for me to debug programs using cedf tool., even if the program was object code with this tool you were able to intercept CICS commands and sql commands. I have a delphy application., only object code....more >>

I need some assistence here. I have two servers. One with MS SQL 2000 Standard edition and MSDE(MS desktop engine). I need to sync my databases nightly, as a backup. Is there a cheap software that will do this? I don't want to just backup the entire databases files b/c they are large an...more >>

Hello all, I have a scenario in which there are three tables, A, B and C. A and B have PK columns, both are of the same type. C has a FK column, of the same type as the PK columns of A and B, but the values in it should be either in the PK column of A or in the PK column of B... I figured o...more >>

I am trying to "Edit Recurring Job Schedule" in a new maintenance plane, however in start and end times there is no option or display for AM or PM to select. I have seen on other systems an available AM/PM in the time window. I tries entering the time in 24 hour format, but that was not recogni...more >>

SQL Server 2000 SP3A Last week one of our processes starting issuing or suffering deadlock detected errors every 15 minutes or so. I have read several articles at MS on the subject. I set a couple of startup parameters related to producing deadlock detection information and ran SQL Profile...more >>

Hello everybody, does anybody know how to export databases from SQL Enterprise to SQL Express 2005? thanks in advance Luca ...more >>

What is the meaning of *= in SQL? For example, what is the difference between the query select c.customernumber, o.amount , i.[description] from customers c, orders o, items i where c.customernumber = o.customernumber and o.itemnumber = i.itemnumber and select c.customernumber, o.amount...more >>

Hi all, I am new here and also new for using psql, I hope I joined the correct google group to ask question ;-) Here we go~ I create one table: CREATE TABLE positions ( id serial NOT NULL, name integer ) Then I type: \d++ then it shows: public | positions ...more >>

Hi, I have wrote the following sql sentence.Do you have comments to improve the performance.I have created all the indexed. But it's still very slow.Thanks The primary key is proj_ID and Task_UID. SELECT PR.PROJ_NAME AS PRName, PR.PROJ_ID As PRProjID, PR.TASK_UID As PRTaskUID, 'Dev' ...more >>

I added a linked server successfully; but the only tables accessible are only the system tables! I do have all the rights on both servers (Windows & SQL server). All the non system tables are designated as DBO. Strange thing is that I was able to access the non system tables only from th...more >>

Sorry, the prior message was multi-posted. Here's a cross-posted version. Please disregard the other one. Is there a way to create and encrypted database file? What do people do when data security is important at the file level? In other words, you don't want anyone to be able to take t...more >>

Is there a way to create and encrypted database file? What do people do when data security is important at the file level? In other words, you don't want anyone to be able to take the database file (or files) and extract data from them. Ideally, I want a file the is absolutely encrypted o...more >>

each table has a auditime field which keeps the last data who modified. I set this field as a datetime datatype and default value is getdate(), so the value is recorded like this 10/12/2004 7:28:02 AM. When I query to get that value, nothing showed up. I made a query as below select auditime fr...more >>

I get a 90-120 second blocking when send 15 or so simultaneous queries to SQL Server 2000 that query a view made up of two joined tables. After each query is blocking for the same amount of time they all return. Further identical queries of this type work in 3-4 seconds (caching?) until hours l...more >>

I have a situation where attending a meeting could be either staff or coalition members. But don't know how to enforce a foreign key constraint. any ideas ? Table Meeting MeetingID int NOT NULL, AttendeeID int NOT NULL Primary Key (MeetingID, AttendeeID) Table Staff StaffID int...more >>