Viewing 15 posts - 2,056 through 2,070 (of 5,103 total)
Sorry but you CAN change the table columns not referenced by the VIEW even when it is defined with SCHEMABINDING!
Fix your "correct" anwers.
create table dbo.test ( col1 int, col2 int,...
April 18, 2007 at 3:59 pm
Note that it didn't work while trying to delete files "across the network". but that does not means that it will never work.
April 18, 2007 at 7:37 am
In 2000
get the sql_handle for the spid and use
DECLARE @Handle binary(20)
SELECT @Handle = sql_handle FROM sysprocesses WHERE spid =
SELECT * FROM ::fn_get_sql(@Handle)
In 2005 use
SELECT session_id, text
FROM sys.dm_exec_requests...
April 13, 2007 at 4:03 pm
note that stored procedures allow for deffered name resolution and you may be missing something although the procedure code didn't complain ![]()
April 12, 2007 at 11:18 am
From BOL: ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/d308d9cb-bb85-46f6-93c6-e2ddd0fa01c3.htm
Note:
AWE is not needed and cannot be configured on 64-bit operating systems.
April 12, 2007 at 11:14 am
Tables partitioning are not *that* great either. Be really careful before you jump into that, thinking that "peformance" is its primary feature, it is *not*.
In addition when replication is involved...
April 12, 2007 at 9:41 am
First suggestion: UPDATE your STATISTICS. when you installed the SP you may have flushed the cache
Suggestion #2 NOLOCK statements on the FROM of an update statement are supposed to be...
April 11, 2007 at 11:03 am
can you post the DDL for dbo.afectacion table ?
Timestamp is *not* a datetime in MSSQL
April 11, 2007 at 10:52 am
The functions of this service remain unchanged: These are the functions described in the 2000 version of the product
April 10, 2007 at 8:51 pm
April 10, 2007 at 8:30 pm
If the view can be converted to an "indexed view" it *is* possible to replicated the view as a table.
April 10, 2007 at 7:51 pm
Viewing 15 posts - 2,056 through 2,070 (of 5,103 total)