Viewing 15 posts - 766 through 780 (of 2,647 total)
You're going to need to paste the code you are using and a sample file. Something is probably wrong with the file. Is it uniformly formatted?
June 6, 2012 at 11:35 am
When you assign a domain account to the service through SQL Server Configuration Manager or during installation, it grants the user the proper permissions by assigning it to a "virtual...
June 6, 2012 at 11:29 am
Try highlighting just that select statement and running it. Does it run or do you get the syntax error? If it gives the error, copy and paste only...
June 6, 2012 at 10:05 am
Ok, let's start with...
1. Why is this "delete from FicheirosImportar where sessaoinicio <> sessaofim and sessaoinicio <> 'T'" in the cursor?
2. @codrf should be varchar(5), not varchar(10)
But, your...
June 6, 2012 at 7:41 am
What query is timing out? For example, are you trying to do this all at once or one table at a time? If it is only 1 table, how...
June 5, 2012 at 1:21 pm
From BOL:
BULK INSERT can import data from a disk (including network, floppy disk, hard disk, and so on).
June 5, 2012 at 12:45 pm
guerillaunit (6/5/2012)
Hi Sergei, I tested my data sources on my Reporting Service intranet and the tests were all successful. Any other idea on what might be causing this?
You still...
June 5, 2012 at 11:52 am
DBA_SQL (6/5/2012)
Ya I just did that...but does the bcp won't take the files from network location..
I'm sorry, I don't understand the question.
June 5, 2012 at 11:48 am
Daxesh Patel (6/5/2012)
Maybe you should read up on SQL Server Agent Alerts so you can see what they can do?
Here's a sample: http://msdn.microsoft.com/en-us/library/ms186385.aspx
Yes there are capabilities to setup...
June 5, 2012 at 11:24 am
guerillaunit (6/5/2012)
What are you referring to by "solution"?
Sorry... It would be the Project in BIDS (Visual Studio for SSRS).
June 5, 2012 at 11:21 am
Do you have 1 solution, or many that are used for creating all of these reports in BIDS?
June 5, 2012 at 11:13 am
Gans (6/5/2012)
===================================
Exception has been thrown by the target of an invocation. (mscorlib)
------------------------------
Program Location:
at System.RuntimeTypeHandle.CreateInstance(RuntimeType type,...
June 5, 2012 at 10:58 am
Daxesh Patel (6/5/2012)
To know % free space we need to find something ouside of sql like perfmon, psinfo, wmi...
June 5, 2012 at 10:55 am
bubby (6/5/2012)
Thanks,Bubby
Not trying to be a jerk, but in the future please restate the subject or question in the post instead of leaving it to the subject?
June 5, 2012 at 10:51 am
Viewing 15 posts - 766 through 780 (of 2,647 total)