Search results for query: *

Hello, i cant seem to find a previous post that covers my particular issue. Here's the problem. I have a table, it contains a column (MyText) of text datatype. Using a stored procedure, I want to update the value in MyText (for a given id) to a value stored in a variable. how would you do...

FANTASTIC! Thanks ever so much, that's a great help.

Hi, i'm wanting to write a script to output all my user tables that have a primary key field(s), BUT also NO foreign keys in the same table. Would any one point me in the right direction as to which tables would hold all this data for me, or any SPs that already do this? Any help would be...

FANTASTIC! Thanks very much.

Hi, From viewing the status column in sysdatabases i can determine the status value. However, the DB in question is a DB that is being restored (marked as IN LOADING) should have 32 in the status column, 32 being the value attributed to a DB in loading. I have 48 in there though, i guess that's...

Hi, This may not be the correct forum but if you could point me in the right direction it would be much appreciated. I am trying to import a number of rather complicated XML file into SQL Server 2000 using VB in an ActiveX script executed through a DTS pack, but my knowlede of xml is limited...

Hi, How can I get the taskpad view as the default view for whenever I click on a servername, or database name??? without having to go through each db/server and manaually set the view to taskpad? thanks in advance...

Hi, I have a dts that contains just one step and that's an ActiveX script. the script reads a text file into a variable, writes a new text file and executes the sql stored in variable that got populated from the file read. When i run the DTS from the Designer it all works great, though when...

Hi, When adding linked servers to any SQL Server, which security issues should be considered? Any? What settings are best for adding linked servers to SQL servers, all of which are local/in-house and not live? Thanks for any help...

cheers guys! that's amazin help. will find some time this week to put it together. thanks again

hi, wonder if someone can help me please. firstly i hope im posting in the right forum, i think so, cos my situation relies heavily on dns and dhcp. I have a 4port wireless router with builtin modem for my adsl connection. it's currently set up using nat, and it is currently my dhcp server and...

thanks for the help! appreciated.

Hi, in the sysjobschedules table, should freq_type = 8 (weekly), then freq_interval is a bitwise value and 1 = sunday, 2 = monday, 4 = tuesday, 8 = wednesday, 16 = thursday, 32 = friday and 64 = saturday. How from the single bitwise value, do I extract which of the above day(s) the bitwise...

Then, since the database as a whole will have good data in it before deployment to live and all keys are correctly scripted before any inserts, then all is okay. I already have the script i want, except that I had to manually create a bunch of Insert Intos for each record in each table and it...

Thanks for the reply. Number of records will be less than 100, probably less than 10, per table. Data coming in will stop when we're ready to go live, and so my resolution here is to run this SP that I'm trying to write to go get what's in the database at that time and that would be good...

Well...what we have here, is a company policy if you like, that any new database schema is entirely scripted (tables, keys, indexes, constraints, SPs etc) including initial "start-up" data. This script will then get executed in the QA environment, then when everyone's happy, in the Live...

Hi, How, in T-SQL, can I get my cursor to iterate throught the fields in a given table outputing the values in each field? I'm trying to build a sp to automatically go through all my tables, then all my fields, then build a bunch of INSERT INTO mytable (myfields) VALUES (myvalues) statements...

Cheers. Thanks for your replies.Im keeping the code generic so i can pop this trigger on other tables, and let it think for itself as to what the primary keys are in each table and fetch their vlaues out from the inserted/deleted tables and stitch them together into a string. I might try...

well, due to our auditing method, i require to caoncateneate all the primary keys in the trigger table. in an attempt to generalise the trigger, to limit any hardcoding of field names, i've used sp_pkeys within the trigger to put the primary key fieldnames into a temp table then a cursor to loop...

hi, I have this inside my trigger EXEC ('DECLARE @PKValue varchar(255) SELECT @PKValue = ' + @PKField + ' from inserted') Though the trigger does not execute despite that it parses okay. Is it not possible to view the inserted or deleted tables inside a trigger when the SQL to do so is...