as referred here ... in August ... http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=11814 I just received the same email from the same...
Hey there, just recently I have been receiving some alerts with the following Error. * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION It...
Hey guys, First of all, I don't know whether this topic should be posted here or rather in the "DTS packaging" section. Anyway, here we go. It...
Hey guys, I am trying to trap the following thing: ---------------------------------------------------- declare @myInt int select myInt =...
Hey, could anyone explain why Select isnumeric('00X418975') --> raises 1 and Select isnumeric('00D418975') --> raises 0 (which is the expected...
Hi there, I have been trying (with EM) to restore 2 different database backup files (complete database and post differential backup) on a different...
Hey guys ... I have a "not that enormous" table (400.000 regs) with 100 users accessing it ... I am receiving continously (and even after repairing...
Have u ever wished there was a built-in role called "db_spExecutor" (it's just an idea) that would allow its members to execute all stored procedures...
Hey guys, here is the astonishing behaviour of a query that returns the same records whatever be it the WHERE clause ... It is a simple table with...
Hey guys... I don't exactly know whether this is the correct place to issue this suggestion or not, anyway, I drop it here. As I don't know if you...
Have u ever experienced the issue of having to restore a "production" backup database on a "test" server and finding that all your security/users...
hi there,<br /><br />is there any "off-line" way to set up the SQL Server authentication mode? (Mixed, Windows ..)<br /><br />All I get is the...
When it comes to security in DTS, I have read http://support.microsoft.com/default.aspx?scid=kb;en-us;282463 and it gives some clues about DTS...
Aha, hélas, here we are in the middle tier issues ... the middle tier, that service which allows applications to interact directly with a service...
hey guys... as you probably know, theres an option in those maintenance plans (I guess thats the name in english) that allows you to delete previous...
Hi there guys... Imagine u have the following scenario : Database_A with a backup and A_data, A_log logical file names Database_B with file names...
hey there community ... I am trying to set fields as IDENTITY after having imported a table from a data source ... so, lets say I have the...
hey community ... I have found a difference between what SQL 6.5 (very old stuff, I know) and SQL 2000 are returning when CURRENT_USER is invoked...
hey folks, I have found this error/bug in some of my user's applications ... Bug #: 470138 (SQL Server 8.0) SYMPTOMS When you run a Transact-SQL...
Hey community ... In my department we are developing a SELECT with 3 levels of nesting SELECTS ... that would be, for instance SELECT a, (select b,...
Separate names with a comma.