Search results for query: *

I want to simply use a table name as a variable i.e. Table_Name = cube_unit_@_events_scp Where the @ sign is it could be one of three options (for table)Do I put the tableName variable here or the report type variable? What I want to say is if this is the report type then use this table, if...

Put the word SET in front of all columns you want to update. Don't forget to declare your variables. Good Luck! Christine1

I'm not clear on your question, but I have a few of my own. Which column of which tables are you updating? In other words is this what you want to do, if so you were only missing your SET clause: UPDATE Contents SET Font = 'Arial' WHERE Contents.Entity_ID IN (SELECT...

Sure would appreciate taht waggers. Good luck to you in your endeavor and keep us posted. By the way I too have to use the back up and retore method which weighs down the network tremendously anytime I have to copy a file across it. See ya, Christine1

waggers, how are you going to go about it? I don't have nearly as many servers but enough that we really need synchronising across the board. I don't know where to begin. Let me know how it turns out. Christine1

Thanks Tom. Now where in the statement do I enter the EXEC command and where do I address the variable (see statement above)? Christine

Robert, I'm still using 6.5. I've heard and had nothing but bad experiences on replication in 6.5. Any insight/advice on this? Christine

I too want to know the answer to this one. I currently use the back up and retoring method across 4 servers. I wish there was an easier and quicker way. It takes up production time and valuable network resources. Any advice out there? Christine

Scott, I cannot offer any insight however, I also am in the same situation. I want to know if it is feasible to go from 6.5 to 2000? Is it recommended? Are there known conversion issues. And finally the one I most have issues with, how to configure SQL Server on NT 4.0 to run and optimal...

Okay, Tom In my haste to post this problem I'm having I crossed the comment block ***/ instead of /*** If my statement is longer than a line I use 3 asterisk, but that's not my issue. I have only commented them out for this posting. Again the question is HOW TO WRITE a table reference as a...

Yes. I guess I did offer more than I actually needed to. But the scenario is this, Depending on the report, it may need one of three tables. Never all the tables at once. i.e. The apple report needs to pull from the apple table, red report from red table. I wanted to use dynamic SQL rather...

Hi everyone, I am trying to improve one of my sproc's instead up having 3 sproc's that do the same thing, just call FROM 3 different tables. I want to use 1 sproc that utilizes Dynamic SQL to to do the same thing using the variable. Here's my code can anyone tel me where I'm going wrong and...

Okay, so you are saying declarations should go first (move that select statement)? Yes, cube_control is the table not cube_control_tbl (sorry about that) You are correct about the IF UPDATE that's why I cannot get that to work, but it has the concept I'm looking for. I still cannot get it to...

Good morning, I'm trying to create an Insert/Update trigger (see trig below)Here's what I want to do: If the record does not exist in the inserted table then insert into cube_control_tbl, if it does and the record has changed then update. What am I doing wrong??? Please help I have to have...

I keep getting syntax errors. I'm sure I am leaving off something. Here's what I've got: dbcc dbrepair DBNAME error dbcc dbrepair_rebuild DBNAME error Do I need to add a dropdb? Please help as this db is mission critical to the company and I am holding up process. P.S. The database is 6.5.

Okay, this is not happening. I recieved the following error message: Msg 625, Level 20, State 1 Couuld not retrieve row from logical page 3855464 via RID because the entry in the offset table (=0) for that RID (=9) is less than 0. The SQL Server is terminting this process. If in...

You can try to do a data transfer also. I assume you already have created the dB on the remote server, so transfer all the data. (sometimes has errors) Or you could back it(data) up to a back up device then copy it into the backup folder in MSSQL on the remote servers hard drive then go to...

There are several ways to check this. What I did was create a status table that would record getdate() Time started and Time completed of the sproc being run. I can refer to that table and check what has run, when and how long it took to run. If you are speaking historically, try checking the...

GAM, I agree with FoxDev. If you are using an ODBC connection and using NT security, a user should be able to log into the network and have acess to the database(s)you have granted them permission to. When they open a connection to a database server, if you have set up the SQL server to use...

Thanks for the advive. I agree with you both, first, that cursors will hender SQL performance and secondly, programmers often come from a sequential progamming background, hence the creation of the cursed cursor :-). I have a lot of work in front of me as I have over 100 sproc's that need to...