And another: http://www.sqlservercentral.com/articles/T-SQL/68376/%5B/url%5D 😉

The discussion reveals some alternate methods as well.

If you go here: http://msdn.microsoft.com/en-us/sqlserver/bb895958.aspx and download the Release Notes (ReleaseNotesSQL2005SP3.htm), you will find a list of issues that you may have when upgrading. At a quick glance, most...

reddy06 (4/14/2010)

---

in the new table i should insert 100 records

new table has 5 columns

i have the hardcoded values of 1st 4 columns

and the 5th column value should be cell(1,1) of...

So you want to select all...

I like the linked server option, if you are willing to create linked servers. Otherwise, why not use an ad-hoc query?

INSERT INTO localdb..localtable

SELECT *

FROM OPENROWSET('MSDASQL','DRIVER={SQL Server};SERVER=RemoteServer;UID=YourID;PWD=YourPass',remotedb..remotetable)

Thanks. 🙂

Have you found the size of the largest value in your TEXT field? Try:

select len(max(yourtextfieldname))

from yourtablename

Also, changing the datatype of the TEXT field to VARCHAR(MAX) will allow a character...

As far as I know, there is no way to record HOW a record was updated (sproc, ad-hoc query, etc.). An after update trigger is fired as a result...

I'm not sure what you want exactly...do you...

GabyYYZ (3/9/2010)

---

Seth Delconte (3/8/2010)

---

Yes it certainly looks that way - even the reference links are the same. A little...

Yes it certainly looks that way - even the reference links are the same. A little credit would have...

DBCC TRACESTATUS(-1) will show the current connection's status for all trace flags (global or session).

You may need to enable traceflags if you have no trace flags for the...

How does this work for you:

select replace(str(month(getdate()))+'/'+str(day(getdate())),' ','')

Could the problem just be network speed?

And you are absolutely sure you are using the correct domain account password?