Search results for query: *

Hello All, In my organization we have developers that create stored procedures under their windows login. When the proc is ready to go to production, they send it to the DBA group and we change the owner to dbo. Problem: The developers would like to debug some of the stored procedures that...

Figured it out.... EA3 and EA7 are linked servers. The old sa password had not been changed there yet through Enterprise manager.

Hello All, I changed my sa password and ever since I have done that I am getting a login failed for user sa when I try to run the following query: SELECT ADJDOCNUMBR AS transid, ORTRXAMT AS original, CURTRXAM AS due, (Select top 1 upload_date from dtp where transid = ADJDOCNUMBR order by...

I have a database with 310 tables in it. I need to have these tables replicated to another server. I have been told that it has to be continuous transactional replication. Can anyone suggest the best way to set up my publications? It seems like when I try to set up the publication to do all of...

I have replication set up as transactional and continuous to run whenever the CPU is idle. What sort of problems has anyone encountered with this?

Hello All, I was informed that we are going to start replication between the office that I work in and an offsite location. I was asked to research if there are any bandwidth issues in doing this and/or to get recommendations on what kind of bandwidth we need to have. Any help would be...

Hello All, I recently started a new job and as I am looking through the tables in the databases we have here I noticed that some of the tables have 30 indexes on them! I don't think there is a need for that many. I'm confused about which ones to get rid of or change though. Here is a sample of...

Thank you hmckillop! Your feedback helped me to understand better why this was happening. After reading your post I ended up copying my production tables that this query was using over to my development server (I was not having the same problem on production). That fixed the issue. So, I am...

I rewrote the query so now it looks like the syntax below. I verified that I have indexes on my tables as well and I am still getting the same message. I ran sp_lock in a seperate window but nothing is jumping out at me as being wrong. Can anyone please look at my output from sp_lock and let me...

Does anyone have any other suggestions?

I tried using NOLOCK (see syntax) and I am still getting the error message. SELECT (tu.user_name_first + ' ' + tu.user_name_last) as RepName, fv.key_eautorep as RepID, sum(case when cs.isFleet = 1 then 1 else 0 end) as eFleetCount, sum(case when cs.isFleet = 0 then 1 else 0 end) as...

Hello All, I am trying to run the query below in query analyzer and I keep getting the following error message: Server: Msg 1205, Level 13, State 2, Line 1 Transaction (Process ID 53) was deadlocked on thread | communication buffer resources with another process and has been chosen as the...

The problem is fixed now. The solution was that the windows password must be the same on 1. My network login 2. The local login to my workstation 3. The remote server that the database is housed on Thanks for all of your help everyone.

Jason, I did as you suggested and this is what I am seeing.... I have a windows login set up under Security/Logins. The login name as I see it in SQL Server is CRM/sam005. This user also has access to the databases that I need. I can log onto the server using SQL Authentication. I can not...

Yes, you can put a unique constraint on the text field. To do this perform the following steps: (In Enterprise Manager) 1. Right click on your table and select design table 2. Right click on any column name and select Indexes/Keys 3. Click New 4. Give your index a name and select the field that...

Jason and Claire HSU, Thanks for responding. I do not have a front end application. I am just trying to connect to my database through enterprise manager using Windows Authentication. When I right click on the server in enterprise manager my authentication is 'SQL Server and Windows'.

I have a server called CRM. I have a windows user name and password to connect to this server. My username is CRM/Sam005 I have a SQL Server database on the CRM server. I have a windows login set up in the database. My login is CRM/Sam005. I have checked to make sure that the authentication...

At a previous job I was able to right click on a stored procedure, select debug and then I was able to step through my code and view the data in each of my variables. I am at a new place of employment now and when I right click on the stored procedure and say debug, the debugger runs right...

I want a query to select records where the date is equal to today's date in mm/dd/yyyy format. Example: Select * from Table1 Where date = getdate() When I do this I am getting back a time as well and I'm not getting any records returned. I have tried to format the date as follows...

I have a form that a user can enter in a department that they need information for. If the user types "CSV" (Customer Service) I want my query to go to a lookup table and pull data where the code in that table is "CSV" or "ASQ" (which is another name for Customer...