RE: PROBLEMS WITH THE SQL SERVER AGENT AND JOBS
Thanks a lot for your help, it was very helpful!!!!!!!! regards,Amaury Coria Ramirez
2005-05-16
SQL Injection
Controlling Page Breaks in IE
HiI dont seem to be able to control where page breaks fall when viewing RS reports in IE.Page Size settings only appear to have an effect when the reports are exported into pdf etc.Any help on how this works appreciated.Thanks
2005-04-29
RE: Question of the Day for 15 Apr 2005
Yes they are. Found an other article which does.http://www.microsoft.com/sql/spotlight/expandsqlserver.asp
2005-04-15
RE: Allowing users access to jobs in EM
Try this link, or copy and paste the original and add &forumid=5 to the end http://qa.sqlservercentral.com/forums/shwmessage.aspx?messageid=110031&forumid=5
2005-03-23
RE: Creating Views: Changing column names
I have another one that I'm trying to solve: Create another view that returns the name of each country and the number of orders shipped to that country. Name the number of orders column "NumOrders.” Include code that checks if the view already exists. If it does, it should be dropped and re-created. Can any one […]
2005-03-12
RE: Trace discrepancies
Allen,I found the culprit.... our networking group was doing some "maintenance". They were replicating 2 terabytes of data to a mirrored server... it must have eaten all the bandwidth. They denied it when I asked, then boasted about it at a meeting Friday afternoon.... GRRRRRRR. Thanks for all your help. The wait time really was […]
2004-08-24
Torn Page Error - Error: 823, Severity: 24, State: 2
HelloYesterday I got a bit of a fright when I received the following Alert:DATE/TIME: 19/07/2004 14:07:27DESCRIPTION: Error: 823, Severity: 24, State: 2I/O error 1450(error not found) detected during read at offset 0x000001d3b42000 in file 'R:\Data\dbName.mdf'.COMMENT: (None)JOB RUN: (None)Looking this up on Google revealed a solution that involved restoring from the last good backup We run […]
2004-07-20
360 reads
RE: Installing RS possible?
Just copying the DLL to the system directory will not register it. From a command line in the directory where you place a DLL, enter:regsvr32 authz.dll
2004-06-19
RE: Taking parsed string and assigning variables without using a temp table
Thank you for responding. I really like the method you suggested...I'll give it a shot.Demicoq
2004-05-01
NO LOCK vs FOR BROWSE
Hello All,Someone asked me today about FOR BROWSE and I got stumped.I use in most of the cases NO LOCK hint for Select queries and never heard about FOR BROWSE before. I checked BOL and MS site ( below link) and still wondering if anyone use it (FOR BROWSE) in real life for ASP/SQL Server application.http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dblibc/dbc_pdc02_4tb9.asp TIA
2004-04-07
29 reads
Blogs
Not Selected for the PASS Data Community Summit 2024
By Steve Jones
I got this in an email about a week ago from the PASS Data...
A New Word: Addleworth
By Steve Jones
addleworth – adj. unable to settle the question of whether you’re doing okay in...
Data Technology Learning Resources
Hey all! Quick one here. Tracy Boggiano, awesome person that she is, has put...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers