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...

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...

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...

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...

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...

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...

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...

hi, how can i tell which field/s in a given table is/are the Primary Key/s???? thanks

Is it possible, from within a trigger, to determine the name of the trigger-table that fired the trigger???

Hello, Is a primary key (apart from being unique) also an index? Or is it possible to have unindexed primary keys? thanks!

Hi, sometimes when i read the job history, i rarely find an entry that isn't truncated - how can i find the full message, it always tends to truncate just where the most useful piece of information is. thanks.

Hi, i've unsuccessfuly found a previous post regarding my matter so I hope someone can help me! I have a laptop that needs to connect to the internet at work using a predefined ip, subnet, dns and proxy server information. When i bring it home, i want it to simply use no proxy server and...

We have a job that runs as a owner that is NOT an NT account. The job logging (under the Advanced tab on the job step properties) to the .log text file fails when the job runs on the Windows 2003 operating system, though succeeds when executing under Windows 2000. Can anyone shed any light on...

Hi, i'm populating aglobal variable with some characters. it's of the string datatype the global variable is, though when putting lots of stuff into it, the GV doesnt hold all of it and ends up being truncated. So what data type do i assign to the GV so that it holds say up to 2 or 4 or 8...

Hello, any idea as to how you can quit a DTS pack mid-running? Cheers.

Our My Computer properties shows a total memory amount of 2 GB, but the Task manager shows 4GB. SQL Server on this system is configured to use up to 2GB of memory. Is SQL Svr causing that discrepancy between the task manager figure and the My Computer preoperties figure??? And so...when does...