Search results for query: *

I caught it before it went to multiple production boxes. Only one was impacted. Whew! Ashley L Rickards SQL DBA

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

also .. then backup the db and you can use it for a template or run the script on the Model db so when a new db is ceated you'll alway's have that structure. Ashley L Rickards SQL DBA

Right click on the db and select all tasks and generate sql script. select show all and select all tables and sp's. save it to a file create the new database. then open in query alalyzer and run it on the new db. you might need to tweak the script if it inlcudes db name etc .. HTH Ashley L...

right click on the server name in EM and select "edit sql server registration properties" . Select the option to "use sql server authentication" and "always prompt for login naem and password" HTH Ashley L Rickards SQL DBA

Thank you very much! This works great. Ashley L Rickards SQL DBA

I'm looking for the same utility. Did you ever find anything? 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

I used GlowWorm27 code to create the trigger and the table but I get this error. Any idea. 'Another user has mofified the contents of this table or view; the database row you are modifying no longer exists in the database. Database error 'microsoft odbc sql server driver sql server Incorrect...

Check your hard drives or raid array maybe a bad disk. Ashley L Rickards SQL DBA

That might capture it .. I'm trying to track some bad code which is causing networkio so I need something more custom. Ashley L Rickards SQL DBA

Something like this: select blocked from dbo.sysprocesses -- where blocked > 0 IF sysprocesses.BLOCKED > 0 EXEC xp_sendmail @recipients = 'user@company.com', @query = 'Select * from sysprocesses where blocked > 0', @message = 'Processes are blocked on IPDOCKET01', @subject =...

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

Reboot the sql box .. the SAN I assume is alway's up. I guess this covers some networking issues .. but the server initialize the logical drives first before starting other services? Thanks. Ashley L Rickards SQL DBA

Yea it's there and online. It seems when rebooted and starting up that sql service can't see it. I then have to manually start the sql service. It uses a domain account. 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

You could also use Indexed Views to increase performance. HTH Ashley L Rickards SQL DBA

Gotcha .. that formatted it right but it only returns one column 12AM. Is my function correct? Thanks. Ashley L Rickards SQL DBA

Here's another one but for hour so 7Am 8am .. 7PM. Any idea's? Thanks. TimeValue(Hour(CTime({CallLog.RecvdTime}))) Ashley L Rickards SQL DBA