NO_BROWSETABLE - What The Heck Is That?
Jun 17, 2004Hi guys, does enybody know what does it do exactly?
SET NO_BROWSETABLE ON/OF?
Thanks much.
Dim
ADVERTISEMENT
SET NO_BROWSETABLE ON ?
Aug 29, 2007I've noticed in my .NET application (with ADO) that whenever a queryis done to SQL Server, a query executingSET NO_BROWSETABLE ONis done before.This has an huge impact on performance, as the round-trip to theserver takes the same time as the correct query. I believe that if"SET NO_BROWSETABLE ON" wasn't executed, performance would almostdouble and network traffic would be reduced.I've tried to find a reasonable answer on the net for this, buthaven't managed. Has someone noticed this and knows how to correct it?rj
View 7 Replies View RelatedWhat The Heck Does This Error Mean?
Aug 18, 2000Hello folks....
I'm trying to run this query in SQL Server 7:
SELECT * FROM Addresses LEFT JOIN Contacts USING (contact_id)
and I get this error:
'contact_id' is not a recognized OPTIMIZER LOCK HINTS option.
Anyone know what this error means and how I can get qround it?
Thanks...
How The Heck Do I Use A GUID As A Foreign Key In MSSQL 2005?
Jun 23, 2007Okay, this is driving me nuts. It *should* be simple but it is not. I've spent the last 4 hours scouring the web for what should be a simple thing to find out.
I have the following tables, but everytime I attempt to create a foreign key constraint for the StudentLocations table I get an 'invalid type' error. I have a GUID as the PK for the Students and the Locations table. However, since I cannot create two GUIDs (as far as I can tell) for my StudentLocations table, I have instead defined the StudentLocations.StudentID, and StudentLocations.LocationID as binary(16). Unfortunately, I can't match this binary(16) to the GUID Identity in a foreign key because I keep getting this stupid error of 'invalid conversion type!'.
So, how do I do what I am trying to do using GUIDs as my PK for the Students and Locations tables, and the above defined StudentID, LocationID in a StudentLocations table?
Thanks in advance for answering this question. I should spend 5 minutes searching and then come here in the future...it's way less frustrating!:
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Students]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Students](
[id] [uniqueidentifier] ROWGUIDCOL NOT NULL CONSTRAINT [DF_Students_id] DEFAULT (newid()),
[first_name] [nvarchar](50) NOT NULL,
[middle_name] [nvarchar](50) NULL,
[last_name] [nvarchar](50) NOT NULL,
CONSTRAINT [PK_Students] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Locations]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Locations](
[id] [uniqueidentifier] ROWGUIDCOL NOT NULL CONSTRAINT [DF_Locations_id] DEFAULT (newid()),
[address_1] [nvarchar](50) NOT NULL,
[address_2] [nvarchar](50) NULL,
[city] [nvarchar](50) NOT NULL,
[state] [nvarchar](50) NOT NULL,
[zip_base] [char](5) NOT NULL,
[zip_four] [nvarchar](4) NULL,
CONSTRAINT [PK_Locations] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[StudentLocations]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[StudentLocations](
[id] [uniqueidentifier] ROWGUIDCOL NOT NULL CONSTRAINT [DF_StudentLocations_id] DEFAULT (newid()),
[student_id] [binary](16) NOT NULL,
[location_id] [binary](16) NOT NULL,
CONSTRAINT [PK_StudentLocations] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END