ok the query i gave works for objects created WITH SCHEMABINDING... in that case, the referencing_minor_id is not zero, which is how i get some results for column names on...

SELECT

OBJECT_NAME(depz.referencing_id), *

FROM sys.sql_expression_dependencies depz

INNER JOIN sys.objects objz ON depz.referenced_id=objz.object_id

LEFT OUTER JOIN sys.columns colz ON objz.object_id = colz.object_id

...

ok hang on, i believe that code returns procedure or function dependancies...testing it now;

i have a couple of otehr examples too.

there sure is:

this example will give you all columns that have a certain name;

if you want to specifically limit it to a specific table also, simply uncomment out the table...

the best, most foolproof way is to backup the database, and restore it on the other server, with whatever name you would like. That is the standard recommendation.

everything other than...

would you expect your function to remove high ascii characters as well?

i had posted a solution in your other thread on a similar strip function;

what would you expect for...

if a transaction rolls back or fails, the identity() columns still increment.

it sounds like an error occurred inserting the data that was not handled/reported by the .net application.

i've seen...

linked servers are slow for updates; it's usually because the far table (which might be huge) gets copied over into a local temp table, then the data is merged for...

lets double check some settings...by abstracting out your code to be anonymous (SERVERA and SERVERB, something got lost, i think.

first, i don't think its necessary to use EXECUTE AT.

you can...

i think only simple DML queries will work on 4 part names;

you have to issue commands like that with EXECUTE.. AT for commands, SET or DBCC options.

EXECUTE ( 'set IDENTITY_INSERT...

sandeep rawat (8/14/2012)

---

I do agree on the point in case of if linked server is also SQL server .

But in that case u should have same set of user name...

check out this project over at codeplex:

http://standardeditioncdc.codeplex.com/

it is a project that someone built that ads a CDC-equivilent to 2008 Standard.

StandardCDC is a project to enable customers on Standard Edition SQL...

I've got the Kindle Fire, it's great for what it does. I got mine at Christmas 2011, so I've had it for 8 plus months.

Email, web, some cute apps all...

well, it depends on how your server is used.

C:\Windows\System32\LogFiles is the default location for some log files, and the IIS and the ftp service might generate log files in some...

things i would look for

:

review each database on the server. How many have huge log files? this post from today is a nice start:

http://www.sqlservercentral.com/Forums/Topic1343996-391-1.aspx

how many of the databases are...