Search results for query: *

We just ran into an issue with AWE enabled 32GB RAM. Will only recognize 16. Ashley L Rickards SQL DBA

How can I take a field in one table that has multiple values and Insert it into a new table so I have a single record for each value. I'm selecting from multiple tables and creating a new table with the data but need an individual record. So if the host table has bob, john, tim in field1 the...

Been a while trying to do this. Must be brain dead today. Need to update the 3rd character in a 5 character text string. Something like this: update products set (select left(productname, 2) from products))) = 'X' TIA Ashley L Rickards SQL DBA

Need to setup a job to check sysprocesses and send email when blocked > 0 TIA Ashley L Rickards SQL DBA

This server used to be part of a cluster but that's removed. The drive E is on a SAN. Anyone seen this .. Thanks. 17050 : initerrlog: Could not open error log file 'E:\Microsoft SQL Server\MSSQL\log\ERRORLOG'. Operating system error = 21(The device is not ready.). Ashley L Rickards SQL DBA

Have a date field that's text. In my crosstab i'm trying to only show the month of a call. I used the Mid to extract the mont it's yyyy-mm-dd. Now I need it to be the month name. Ashley L Rickards SQL DBA

I have a db in 6.5 compatibilty mode because of some embedded 6.5 syntax. Anyone know of a tool that can identify where so I can get it fixed and get the db back in 8.0 mode. TIA Ashley L Rickards SQL DBA

I have a db that's in 6.5 compatibility mode because there's embedded 6.5 syntax in several sp's. Is there a way to identify or convert to 8.0? TIA Ashley L Rickards SQL DBA

Isn't it possible to have multiple triggers of the same type? In this case INSERT, UPDATE but with different rules for different fields? TIA Ashley L Rickards SQL DBA

Is it not possible to have more than one INSERT, UPDATE trigger on a specified table? TIA Ashley L Rickards SQL DBA

As you stated if there are multiple Items I would need to list those also. Here's more detail. Thanks. ORDERS ID Customer 1 Company A 2 Company B 3 Company C ITEMS ID OID Desc 1 1 Item 1 2 1 Item 2 3 1 Item 3 SELECT ORDERS AND ALL ITS ITEMS...

Hello, It's been awhile but I need to join 2 tables and pull say Orders from one and Items from the other and concatenate the values.

Hello, It's been awhile but I need to join 2 tables and pull say Orders from one and Items from the other and concatenate the values. Any idea's? TIA ASh~ Ashley L Rickards SQL DBA

It seems when using this on a dashboard only coordinators have access to edit and save. When an author tries to save it prompts for login and password then denies access. Any idea's? TIA Ashley L Rickards SQL DBA

I'm looking for a SP that can interact with an ASP form so users can change there SQL password after a certain period of time. Any ideas? Thanks. [pipe] Ashley L Rickards SQL DBA

In the PersonAddress table in our HRIS db. I want the trigger to fire if the field Address OR City OR State OR Zip is updated. Right now I have it set up with a trigger on each field but there must be a way to consolidate them into one. Any ideas. Thanks. Ashley L Rickards SQL DBA

We have a SQL db that I want to write a procedure for. What I want it to do is set up a trigger that fires everytime someone makes a change to certain tables. The trigger should run a stored procedure or package that kicks the changed records out to a text file that will be loaded into our...

Anyone ever seen anything like this. I'm trying to figure out a way to to convert. We received these files in *.DAT extensions. I'm wondering if this was exported from a UNIX based SQL db. TIA. MSSQL SQL0014 plaid
013030427 D 9÷ ÿÿÿÿÿÿÿÿz$? {$? y$...

I need to change the owner of packages from myself to another. Thanks! Ashley L Rickards SQL DBA

Here's my issue. I need to find names that don't match but with same SSN. Example: SSN NAME 123456789 Ashley Rickards 123456789 Bob Smith TIA Ashley L Rickards SQL DBA