Hi,helloI used the physical file to attach the database:sp_attach_db db,path of .mdf,path of .ldfThe returned message was :The LSN (45512:185:1) passed to log scan in database 'db' is invalid.What's matter? How it's to solve?Thanks in advance
2004-11-12
5 reads
I can't believe that there is a general performance problem with ISNULL as it would have been spotted long ago. I have never had any trouble with it and I have used it extensively for many years.If you have a performance problem then it must be related to your specific query or the database design […]
2004-10-26
I agree, you are better off explicitly typing the data rather than allowing SQL to decide as you can cuase yourself big issues especially if the rules change between SQL versions.
2004-10-22
I assume you're making an rpc call? e.g. exec server.master.dbo.xp_fixeddrives ?I don't see any issues between 2003 and 2k based sql servers.Using QA can you run an sp_who on your remote server? That's my base test.
2004-10-22
just some readingstuff. http://qa.sqlservercentral.com/columnists/awarren/shouldyoubuyasan.asphttp://qa.sqlservercentral.com/columnists/bknight/clustering_a_sql_server_machine_.asphttp://qa.sqlservercentral.com/columnists/kpart/scalingout.asphttp://www.sql-server-performance.com/ew_san.aspandforum http://qa.sqlservercentral.com/forums/messages.aspx?forumid=54it works fine overhere
2004-10-22
I need to be able to set the DTSDestination column dynamically using a variable for the column name. Here is the code I am using: strColName = cstr(DTSSource("ColName")) DTSDestination(strColName ) = DTSSource("QVal") I am getting the error "Invalid procedure call or argument: 'DTSDestination'". I'm sure that I am just missing something.Thanks!
2004-10-04
3 reads
Hi Roxanne,Have you tried writing VB code that uses ADO to execute your built queries?You would need to return the SQL queries in a resultset. So, you might add the following code at the stored procdeclare @sql_stmts table ( cols varchar(8000), from varchar(8000), where varchar(8000) )-- repeat insert below for each query […]
2004-10-02
There was no way to know that the individual running the script didn't have sysadmin rights!
2004-10-01
it sounds like you mean that it is a two part primary key dp + num. so then you could do exactly the same thing except with a self join select... FROM legal a JOIN legal b on a.dp = b.dp AND a.num = 1 and b.num = 2 WHERE rtrim(a.descr1) + ' ' + […]
2004-09-22
HiEnglish aint my first language, so what is the real difference between the two answers:Correct Answer: You cannot do this as the update references two tables. You Answered: You cannot do this as the view contains multiple tables. IMHO - the number 2 is multipleI chose to answer multiple as this answer would go even […]
2004-08-31
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers