that sounds like a [data source] or [shared data source] was added, but does not have saved credentials in it.

check the data source of the report you were prompted with.

so you had cross database queries,and because of the migration, one of the databases is now on another server?

if i have that right, i think you can create an empty...

i encountered that same error way back when i upgraded.

the error message is pretty clear.

if you post the statement we can show you a lot better, but basically , as...

it looks to me like only sys.tables and sys.views have the is_replicated column you are looking for.

select object_name(object_id) from sys.all_columns where name ='is_replicated'

use sys.objects instead of sys.views, and use a filter on type_desc column; WHERE type_desc IN('VIEW','ETC....)

SELECT DISTINCT type_desc FROM sys.objects

select which types you want to use.

Abhijit More (7/13/2015)

---

thxs Lowell the only concern I have in my files it may or may not have headers as well some file has Row Delimiter "CR LF"" and some...

lol Jeff that's evil;

i could do it with Excel Automation in a script task, but all the columns would end up being "column1" "column2" because the first row does not...

i iternate through the datatable and determine the...

i've done this with a script task, but i assume the file always has a header row for the column names, and that i know the delimiters, ie, comma/CrLf, tab/CrLf...

in SQL7/SQL2000, the Builtin\Administrators group automatically inherits sysadmin in sql instances ont he same server, so if you are in the local administators group on server, you have sysadmin, andn...

i still have one sql 2000 legacy machine, and i can connect ot it via SSMS, but the original SQL200 installation had two tools, "Enterprise Manager" and "Query Analyzer"

SSMS combines...

a quick bump on an old post. i just needed to generate some random strings, and had this saved in my snippets. when i tested it, it didn't work,...

take a look at the SQL error log; the default for a normal installation is to log failed logins, so you can browse it with SSMS, and find the ip...

Ray check out this script from my friend Gianluca Sartori; he's posted it several times here on SSC;

he basically takes advantage of how DBCC supports WITH TABLERESULTS, and stuffs the...

i also use robocopy to copy files out to an additional network location; i like the fact that it is smart enough to only move files that changed.