Search results for query: *

Hi all, Here's the problem. I have added a descriptive extended property to all objects database, schema, table, index, column etc. I want to create an output (preferably web, but a sql view would be useful too) that will read the property name and value and group hierarchically. i.e. in the...

Hi, I have a situation where financial information in the source system can be amended or reversed. All records are passed to the DW with each transaction being a fact in the Tran_mvmt table Dimensions include customer, agent etc with all dimensions being Type 2 with begin and end date I...

Hi, I have table A with an field (int) that hold values equating to dates. e.g. 21456 21457 To get date values this is joined to table B 21465 2004-02-01 21457 2004-02-02 I need to update the field in table A so that the numeric value is equal to the date + 12 months. How can I do...

Hi all I am querying a view (on a Sybase server) through a sql DTS. One of the fields returned is a numeric field. Some of the records return 0 even though there is a value in the field. When viewed through the DTS query builder preview a – is returned. If I add convert function to varchar...

Hi Would SQL 2000 see the drive if I added a LACIE USB hard drive on the server and would I be able to create a DB on it? Thansk ** Don't reach for the moon when you have the stars. ;-) TheJFM **

Hi I know I should know this but ... how do I get the number of rows per table back quickly from a database? Ta ** Don't reach for the moon when you have the stars. ;-) TheJFM **

I am rebuilding 2 SQL servers to their new spec. 250GB Raid 0. I am in a dilemma over the best configuration. Do I put tempdb in one partition? How much space do I allocate? Do I put data, logs and indexes in separate partitions? If so what would be the optimum ratio of space 1:2:1 ? Here I...

Hi I have an after insert trigger on a table. It fires on a table to table insert. However an insert by bcp from a sysbase server fails to fire the trigger. Any ideas people? ** Don't reach for the moon when you have the stars. ;-) TheJFM **

I am building a 250 Gb Win 2000 server. Raid 0 array. There will be a single installation of SQL Server 2000. It will not be a transactional system. There will be a daily data push populating all the dBs and tables. What is the best strategy? A.A single 200 Gb drive for data file a...

I have created a DTS that runs when executed from the DTS interface. After scheduling the DTS package fails with the following error. Executed as user: nnn\srvcagnt. The process could not be created for step 1 of job 0x5A777726591F4777777771D130B7 (reason: The system cannot find the file...

Could somebody please give a quick run through of the advantages of this collation? ** Don't reach for the moon when you have the stars. ;-) TheJFM **

How do I stop a windows user from accessing views oand tables by setting up an ODBC link to the data base using windows authentification. I want to force the user to use an sql login. Do I need to dable the BUILTIN\Administrators login? ** Don't reach for the moon when you have the stars...

As part of routine maintenance I script all jobs through Enterprise manager. Is there a way of calling the procedure that scripts all jobs in order to make this a regular task? ** Don't reach for the moon when you have the stars. ;-) TheJFM **

Does SQL 7 have a database setting that is equivalent to SQL 2000's simple mode? Thanks ** Don't reach for the moon when you have the stars. ;-) TheJFM **

I am running a DTS from a SQL Server data source to an Access dB table. How can I ensure that the Access table is truncated before the data is exported to Access? Thanks ** Don't reach for the moon when you have the stars. ;-) TheJFM **

Hi all, I am drawing up the spec for a new SQL 2000 development. I was wondering of there is a good site for assessing the hardware requirements that would be best suited to my needs. Apart from the storage space I envisage ( min 25 GB) I am still wondering whether to go for Raid5 or Raid0...

Hi all, I need to prepare a business case for upgrading from SQL7 to SQL2000. Where is the best resource for a clear, concise spec comparison? Don't reach for the moon when you have the stars. ;-) TheJFM

Hi I need run a batch file located on the E: drive of the server on which SQL server is installed. I have tried xp_cmdshell 'E:\myfile.bat' However the ouput indicates that the system is searching for the file in C:\WINNT\system32 and not in the directory I specified. Any ideas?

Hello people I have a table that returns the following: NUM_TOT B_ST 699 W 1240 X 20 Y 780 V 111 B I need to run a query that will return the sums of NUM_TOT that are grouped by B_ST as follows: W & X Y & V T...

On the system I am working on I cannot use e-mail notification i.e. xp_sendmail. Is there a way to include a net send within a stored procedure in the same way that xp_sendmail can be used? Thanks in advance