Search results for query: *

Hi all, I am trying to have Maintenance plan to work for me to clean or delete Backup which is two days old but the clean up history part of plan doesn't work at all it does cleans history of job, and other thing but not deleting the file of backup(test.bak) is there other way to work on...

Hi all, I am getting this error while firing trigger on over the linked server. I am creating trigger on SQL 2000 database and have linked server (SQL 2005) . I am createing trigger and i am calling insert statement to insert value in SQL server 2005 table!! the error is: [OLE/DB...

Hi all, I am trying to create scheduled job for DTS. I have created new DTS in SQL 2005 but not able to create job out of it. I tried creating Credential and then to create proxy with this: Use master CREATE CREDENTIAL [MyCredential] WITH IDENTITY = 'yourdomain\myWindowAccount', secret =...

Hi all, I am getting this error on SQL server 2005. I have SQL 2005 with sp1 and i am keep getting error while log in to application that connects to the database Thanks

hi all, I just wonat to find out that how can i avoid having block on system? I tried alert but would like to avoid better way and also want to reduce the blocking on the DB at least? suggestion please.. thanks

OLE Automation objects are not supported in fiber mode. [SQLSTATE 42000] (Error 8149). The step failed. Please help!!! Thanks

Hi all, need help to figure out that how can i get last 12 month of data for any given date. i have start and end date. should i do like datediff(mm, 12, getdate()) ?? thanks

Hi all, I am trying to study for the Fundamental II. does any one has latest pratice test or dumps that i can refer to please Thanks

Hi all, is it possible to set up the transaction replication without having down time because i tried creating but when it runs initial snapshot it takes long time due to around 4 Millions records on the single table!! is it possible create without having down time for users to work on db...

the job runs as scheduled every 20 min and it also gets gopied over and restored but still showing the error in the server log!! I created log shipping. Log retore and copy works fine and changes also goes through but some how the error comes like i am getting error in server log is: The log...

The log shipping source (local).test has not backed up for 325 minutes.. this error is getting in server log!!! how can i solve this now!!! thanks Thanks!!

i tried running sp_define_logshippping_monitor 'NAME',1(for NT),1 but still getting Error 14426: A log shipping monitor is alread defined. call sp_define_logshippping_monitor with @delete_existing = 1 please advise!!

Hi why i am getting this error after i create the plan to do logshipping!! after i create plan and when it try to run the full back up then initialization it givs me error saying that: Error 14426: A log shipping monitor is alread defined. call sp_define_logshippping_monitor with...

but how about SQL Reporting Services How can i get that!! Thanks

How can i obtain the SQL Reporting Services and install to create reports? is there a site that ican download from? Thanks

Hi all, how can i get SQ reporting Service Tool to download. any site please!! thanks

declare @cmd as varchar(4000) set @cmd = ' select count(ID)FA00100_count from test1 go select count(ID) IV40400_Count from test3 go select count(ID)POP10100_count from test4 ' exec master.dbo.spSQLSMTPMail @vcTo = 'test@test.net', @vcSubject = 'Record Count',@vcQuery = @cmd when i try to...

when it runs and after some time it gives me error for Exception_access_violation error and fails to run. but it does transfers around 650K data out of around 1.5M data

Which one is better ODBC or OLE to connect Oracle Database? Thanks

I am trying to get data out of one sql 2000 server to second one!! using DTS but i get error saying that EXCEPTION_ACCESS_VIOLATION