Viewing 15 posts - 6,061 through 6,075 (of 8,416 total)
MANU-J. (2/19/2010)
His question was regarding difference in service pack level as he got confused with OS pack level and SQL SP Level.
Oh! I see, thank you MJ.
February 19, 2010 at 5:57 am
MemToLeave, -g switches and such are pretty irrelevant on 64-bit SQL Server.
CSS SQL Server Engineers Blog Post
64-bit SQL Server has 8TB of VAS (virtual address space) to play with on...
February 19, 2010 at 5:55 am
To expand Lowell's post, here is the Books Online entry on Deferred Name Resolution and Compilation.
Paul
February 19, 2010 at 5:32 am
ashish.kuriyal (2/19/2010)
will send you stepwise screenshot
Okay...;-)
February 19, 2010 at 5:28 am
Dave Ballantyne (2/19/2010)
TBH , i didnt know that it did that, seems like that could be helpful but could be wrong at the same time.
No worries. It is a...
February 19, 2010 at 5:27 am
INSERT...EXEC is just a fancy INSERT (with some annoying restrictions, but they're not relevant here). Every data modification command, like INSERT, UPDATE, and DELETE runs in a transaction. ...
February 19, 2010 at 5:23 am
ashish.kuriyal (2/19/2010)
1) click on any table in database.
2) Keep pressing the rightclick and move the table to query window.
3) leave the rightclick and you will be able to...
February 19, 2010 at 4:54 am
Dave,
I think you missed my earlier reply to that point about the negative reseed:
Books Online - SET IDENTITY_INSERT
February 19, 2010 at 4:52 am
Barry,
I had a deeper look at this today, and I'm afraid the news isn't good.
It's complex, so here's a reproduction script:
USE tempdb;
GO
-- Drop the test table type
IF EXISTS (SELECT *...
February 19, 2010 at 4:49 am
My take on Lowell's good contribution earlier.
Lowell, I hope you don't mind 😎
ALTER FUNCTION dbo.StripHighAscii(@OriginalText VARCHAR(MAX))
RETURNS TABLE
WITH SCHEMABINDING
AS
RETURN
(
WITH
...
February 19, 2010 at 3:56 am
ashish.kuriyal (2/19/2010)
drag using right click, like we move our file in explorer from one location to other
From Object Explorer in SQL Server Management Studio to a query window?
Right-dragging, I get...
February 19, 2010 at 3:45 am
ashish.kuriyal (2/16/2010)
select @@Version
and it gives me the result as :-
Microsoft SQL Server 2000 - 8.00.2040 (Intel X86) May 13 2005 18:33:17 ...
February 19, 2010 at 3:39 am
ashish.kuriyal (2/16/2010)
if you cant make it similar to principal then the name should not be mirroring....isnt it :w00t::w00t::w00t:
Can't make any sense out of that. What is your point, please?
Seems...
February 19, 2010 at 3:36 am
ashish.kuriyal (2/19/2010)
sp_helpfile
"Returns the physical names and attributes of files associated with the current database. Use this stored procedure to determine the names of files to attach to or detach from...
February 19, 2010 at 3:32 am
ashish.kuriyal (2/19/2010)
February 19, 2010 at 3:28 am
Viewing 15 posts - 6,061 through 6,075 (of 8,416 total)