Search results for query: *

You can use profiler to track the users ... You can also query from the backend ... Select program_name,hostname, nt_username, nt_domain from master..sysprocesses Where Ltrim(program_name) <>'' You can also use sp_who2 to get the users connected ... HTH, Vinod Kumar

Use a three part name like database.owner.objectName to fully qualify the table to access. eg. Select * from NorthWind.dbo.Customers HTH, Vinod Kumar

DTS is another option you would like to try ... HTH, Vinod Kumar

Hi, replace is one option available ... Like field = repace(field,'-','') You can use the Case Statement construct also to achieve this (provided you know the length of the string): DECLARE @BadStr VARCHAR(30) SET @BadStr = '6169-90' SELECT CASE WHEN SUBSTRING(@BadStr, 1, 1) LIKE '[0-9]'...

You can surely use quotes with OpenQuery(). If you post us the complete code then we can surely debug the problem. Here is an example that works perfectly. SELECT * FROM OPENQUERY([servername], ' SELECT * FROM northwind.dbo.employees WHERE employeeID = ''1'' ') HTH, Vinod Kumar

Donot you have an Identity Column. If you have one then you can update the second set easily like Update WordFileLinks SET fileID=a.fileID + 100000 From WordFileLinks a Where [Primary key] > 10000 -- (eg) and fileID < 7000 HTH, Vinod Kumar

Declare @field varchar(50), @loc int Set @field = '4;4;3;65;43;813;345' Set @loc = 3 CREATE TABLE #temp (PkID Int Identity, Id INT NOT NULL) declare @param VARCHAR(8000) Set @param = REPLACE(@field, ';', ' UNION SELECT ') Select @param INSERT #temp EXEC ('SELECT ' + @param) SELECT * FROM #temp...

Why do you ant to come to your application to do this update? If you are using integrated authentication then you can fire a trigger at the backend for the FundSites that would update the AdminID field. HTH, Vinod Kumar

When using table variables use the declare directive: declare @myTable table (col1 int ... HTH, Vinod Kumar