Viewing 15 posts - 286 through 300 (of 569 total)
Hello,
Has this Linked Server ever worked?
Can you post a screen-shot of the Linked Server General Properties page? Failing a screen-shot please detail each property-value pair.
Regards,
John Marsh
www.sql.lu
SQL Server Luxembourg User Group
February 16, 2009 at 11:53 pm
Hello,
Did you check the data in the File to make sure that all the values in the source for Column 20 can be converted to an integer? (-2,147,483,648 to 2,147,483,647)
Regards,
John...
www.sql.lu
SQL Server Luxembourg User Group
February 16, 2009 at 11:40 pm
Hello Ian,
That’s the kind of thing that I was thinking about.
Personally, rather than a Trigger, I would use a separate step in an SSIS package to move the records...
www.sql.lu
SQL Server Luxembourg User Group
February 16, 2009 at 11:22 pm
Hello again,
Sorry, I can’t help you with your XML questions.
I was just wondering why not to use normal set based SQL methods, or may be I am missing something? If...
www.sql.lu
SQL Server Luxembourg User Group
February 16, 2009 at 8:46 am
Hello,
Assuming that you have other DTS Packages that work Okay on the SQL Server and the fact that you mentioned the Package works fine when run from Visual Studio, then...
www.sql.lu
SQL Server Luxembourg User Group
February 16, 2009 at 8:24 am
Hello,
It sounds like a Data Warehouse application that you are working on? If so, then wouldn’t standard ETL methods work e.g. load the Transaction File in first in to a...
www.sql.lu
SQL Server Luxembourg User Group
February 16, 2009 at 8:00 am
Hi Onvia,
Shame you don’t have the permissions as that would have been the easiest solution.
You could use RedGate’s SQL Compare to compare the DB to an empty DB, and then...
www.sql.lu
SQL Server Luxembourg User Group
February 15, 2009 at 1:46 pm
Hello,
Was it the code from this article?
http://www.mssqltips.com/tip.asp?tip=1349
Regards,
John Marsh
www.sql.lu
SQL Server Luxembourg User Group
February 15, 2009 at 11:15 am
Hello,
If you are deleting all the user tables and therefore the data in the DB, then is there anything that stops you from simply deleting and re-creating the (empty) DB?...
www.sql.lu
SQL Server Luxembourg User Group
February 15, 2009 at 10:58 am
Hello,
If you just want to get a code listing then you can execute the system SP sp_helptext from within the relevant DB
e.g. sp_helptext ‘mySPname’
Regards,
John Marsh
www.sql.lu
SQL Server Luxembourg User Group
February 12, 2009 at 9:50 pm
Hello Again,
Are you using a Shared Data Source? What Security Context are you using to connect to the Data Source e.g. Windows Integrated? If so, are you using the same...
www.sql.lu
SQL Server Luxembourg User Group
February 12, 2009 at 2:31 pm
Hello,
Have you tried executing the report from a browser on the actual Report Server? You should receive a more detailed error.
Regards,
John Marsh
www.sql.lu
SQL Server Luxembourg User Group
February 11, 2009 at 9:42 pm
Hello again,
The best is to create a Windows Account specifically for the SQL Agent Service to run under. That way you can assign exactly the rights required. The MSDN article...
www.sql.lu
SQL Server Luxembourg User Group
February 4, 2009 at 4:14 am
Hello,
You may be stuck with this one as according to BOL 2005: “Although any user with access to a database can create a diagram once it has been created, the...
www.sql.lu
SQL Server Luxembourg User Group
February 4, 2009 at 2:47 am
Hello,
The first record will be for the report folder named “Employee Info Report” (where your report is deployed), and the second record is for the actual report.
“Type” is a useful...
www.sql.lu
SQL Server Luxembourg User Group
February 3, 2009 at 11:57 pm
Viewing 15 posts - 286 through 300 (of 569 total)