Search results for query: *

SQLServer 2005 SQLServer 2000 Can sql server full-text index and apply appropriate word breakers for a unicode column? Data in the column can be in any language. if so, what are the drawbacks? would it be better to keep data separate (1 column for every language or 1 table for every...

nevermind... you can avoid this problem by using @datasrc parameter in sp_addlinkedserver procedure... a little research does wonders ;0)

I have 2 instances of SQL on the same server. SERVER\INSTANCE_A SERVER\INSTANCE_B I create a linked server connection 'LINKED_SERVER' on both instances (the linked server MUST have the same name on both instances... Now, I want LINKED_SERVER on SERVER\INSTANCE_A to point physically to...

hi Gurus. When you create a ERD using Enterprise Manager's diagram utility -- you are able to see column descriptions. (You can also add column description when Designing table in Enterprise Manager. Where in system tables is this value stored? (it's not in syscolumns where it would make the...

Karl -- you are absolutely correct. The scope of the transaction should always be in the stored procedure. However, in this case the transaction is a distributed transaction.... So it 2phase commits a sp to 3 different servers. in any case -- i did some research on this... the case i...

thanks for the answers guys. I got a hold of ms support guy, and he basically told me the same thing... unfortunately, if the network connection get's lost there is not much you can do aside from tracking down the spid and killing it... ;(

you didn't understand the question. i know why blocking happens. what i'm trying to simulate is a network hickup on the connection that started the transaction, which renders the transaction and the session orphaned.

hi gurus. here is how I simulate an orphaned transaction from a query analyzer window: --create table create table xxx (i int) --initiate a transaction (do not commit or rollback) begin tran insert xxx (i) select 1 once the transaction is open, pull the network cord from the client machine...

i guess not... Referencing Objects SQL Server allows the creation of stored procedures that reference objects that do not yet exist. At creation time, only syntax checking is done. The stored procedure is compiled to generate an execution plan when executed, if a valid plan does not already...

hi. when i create procedures that select form non-existing tables, the procedure compiles without error... is there an option that would not allow creation of such procedures?

karl, agreed that it's probably a timing issue. But the results are 100% repeatable.... i'm still investigating. thanks for an interesting solution. As i've mentioned: GUIDs, and identity work! I know that. I tested them. But i can't use them. but since everyone is suggesting them, i'm...

thanks guys. i know this problem is easily solved by Guid's or Identity. Now here's an interesting development. I changed the procedure code update the value first, and this does not generate PK errors.... HMMMMMM... I'll think about this and maybe post the answer when i find it...

raising isolation level causes deadlocks. guid's or identity are not an option (yet). Blocking is not happening in this case (that's why PK violation errors). I mean, if i'm being locked out by something, my query is queued until the lock is released... That doesn't seem to happen here. i'm...

declare @MyResult nchar (50) EXEC @MyResult = master.dbo.sp_addrolemember @role, @username

hmmmm... There has to be a good solution to this, but i can't find it. Hope you guys can help me. Application inserts rows into a table. My code has to assign a new primary key to every row. Ideally the primary key is INTEGER, and every new row gets PK = max + 1. I know i can use GUID's...

all right there, smartass!! ;0) i was typing too fast ;0) a star for your solution. Howeverm I actually wanted to avoid using a user function. Doesn't sql server have anything native for this?

is there a command that will extract the binary components from a number? example 1 in the database: 0000 0111 (7) i need this command to output : 1,2,4 in the database: 0010 1010 (44) i need this command to output : 4,8,32

can table variable be used as an input parameter to sp? can a procedure return a table variable?

if anyone is interested -- here's the solution i found -- i forgot to set LoginSecure property... so the correct code would look like this: DECLARE @object int, @hr int, @return varchar(255) exec @hr = sp_OACreate 'SQLDMO.SQLServer', @object output exec @hr = sp_OASetProperty @object...

hi. Here's the code that gets executed to script objects. I've always used sql authentication for sp_OAMethod, but i'd like to change that to windows authentication... Does anyone know how to code sp_OAMethod to use local windows account? Thanks!! DECLARE @object int, @hr int, @return...