Only if you use dynamic sql or seperate each item to be used.

Ex.

DECLARE @SQLStr VARCHAR(400)

SET @SQLStr = 'SELECT * FROM table WHERE field IN(' + @param + ')'

EXEC (@SQLStr)

"Don't roll...

Also in the trace what EVENTS are you choosing. Looks like the build events. Use the completed instead for TSQL and SP items.

"Don't roll your eyes at me. I will...

Yes you can use bcp to export and then import on the remote server as long as you have a SQL Login or you move the file to the other...

Well I will conceed that this information looks more correct than what I have learned. I am coming from a VC background not worried about the DBA aspect and have...

I do regular backups of my production server, and this happens there once in a blue moon. I believe something was locking the data it was trying to access then...

This should do the trick. Also does not show restores where a database was restored and later a different database was restored over it, only shows the last restore to...

Try this, works great for me (note: only goes to billions at this point, but easy enough to expand). May work even better as a function in 2000.

/* You will...

I get the sometimes and have to shut down the server to correct.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Beyond using model for future database building to have the same files and structure, the answer is no, not without an application to do it. Databases are treated as individual...

quote:

---

When I do same by creating a package at sql server it works fine.

---

If you...

Have you recently changed anything about the server (name, ip address, segment, nic, etc.), Also have you checked the nic to make sure it isn't going bad on you. Also...

You can try the following method, works fine.

CREATE TABLE #tempTbl (

[idx] [int] IDENTITY (1,1) NOT NULL,

[val] [varchar] (8000) NULL

)

/*

/T ...

Ok first I am not using multiprotocol and have TCP/IP defined at my clients.

Any connections made to any server will always interogate port 135, the OS is doing a check...

Try this.

CREATE TRIGGER UrTrName ON [dbo].[tblName]

FOR INSERT

AS

DECLARE @LogID Int

DECLARE @Profile Int

DECLARE @Note varchar(800)

SET NOCOUNT ON

--look up all affected SDG fro the profile

SELECT @LogID = LogID, @Profile = Profile, @Note...

You have a record with a Len(CityState) Less than 2 and is returning a negative number. Try this

Update SWBTPB_format Set CityState = CASE WHEN Len(CityState) < 3 Then CityState

ELSE Left(CityState,...