Connection Search Results
You searched for:
all feedback for this connection
(signing in could show even more results)
We've caught both SCOPE_IDENTITY() and @@IDENTITY returning the incorrect value after doing an insert. It appears to be some combination of our database settings, the number of rows in the tables, an…
Created on 2/15/2008 (updated 1 week ago) | 10 validations | 4 workarounds | 22 comments | feedback id: 328811
|
|
When you connect to SQL using Windows group, you cannot define a default schema. It is greyed out. This means that if you want everyone to be in a specific schema, you can't do it by default. When u…
Created on 2/14/2008 (updated 1 day ago) | 60 validations | 0 workarounds | 8 comments | feedback id: 328585
|
|
Don't get me wrong. I think the new columns we've added to Object Explorer Details are very valuable and provide very quick at-a-glance insight into all of the databases on our server(s) (similar to …
Created on 7/7/2008 (updated 5 weeks ago) | 20 validations | 2 workarounds | 6 comments | feedback id: 355238
|
|
Umachandar Jayachandran recommend that I post this issue on MS Connect. The problem is a breaking change from SQL Server 2000, which prevents us from switching over to SQL Server 2005. The change el…
Created on 11/20/2006 (updated 4 weeks ago) | 15 validations | 0 workarounds | 3 comments | feedback id: 239674
|
|
The SSIS natively and with the added components undouble and undoubleout does not recognise embedded column delimiters in text. For example, if " (double quote) is the text delimiter and , (comma ) is…
Created on 6/11/2007 (updated 5 weeks ago) | 15 validations | 3 workarounds | 14 comments | feedback id: 282396
|
|
According to BOL sysprocesses system view is on its way out of the product.
The column (there may be others) dbid in sysprocesses can not be determined through the execution DMV's.
sys.dm_exec_r…
Created on 2/11/2007 (updated 2 weeks ago) | 3 validations | 0 workarounds | 9 comments | feedback id: 257502
|
|
We have a customer using SQL Server 2000 that is experiencing an intermittent problem with OPENQUERY() to an Oracle linked server:
- The application requests data from the Oracle linked server once…
Created on 8/27/2006 (updated 1 week ago) | 25 validations | 2 workarounds | 5 comments | feedback id: 187192
|
|
If you build a view in Management Studio view designer and select a column to order the results by, a view such as the below is generated:
CREATE VIEW xxx AS
SELECT TOP (100) PERCENT ....
(..…
Created on 1/2/2007 (updated 4 weeks ago) | 6 validations | 1 workaround | 11 comments | feedback id: 249248
|
|
The Remember Password option in the Register Server Properties dialog is not remembered.
Created on 12/7/2005 (updated 1 day ago) | 31 validations | 0 workarounds | 17 comments | feedback id: 124842
|
|
SQL Server allows to created duplicate Indexes with same Meta Data.
What is the point in allowing to create NonClustered Index on same field twice ?
e.g. :-
CREATE TABLE dbo.T1 ( int_ID int , s…
Created on 11/28/2007 (updated 5 weeks ago) | 3 validations | 0 workarounds | 8 comments | feedback id: 313227
|
|