Viewing 15 posts - 526 through 540 (of 1,124 total)
Personally, I don't prefer using OPENROWSET, because it has some securities issues. I recommend you to use Linked Servers, as they are really easy to use. You just...
February 11, 2009 at 9:11 am
josephptran2002 (2/11/2009)
On DDS columns, how can I eliminate the comma if there is only one entry in a cell for example
This part is taken care by the SUBSTRING function in...
February 11, 2009 at 9:05 am
...Thanks for the appreciation:), you really made me feel happy...:)
And the solution...
WITH AllDDS AS
(SELECT DDS, DEClearedDate AS ClearedDate, DECleared AS Cleared
FROM ...
February 11, 2009 at 7:14 am
...Hmmm, looks like these registry keys are created to restrict the ACCESS to certain PROVIDERS within SQL Server.
February 11, 2009 at 7:09 am
K, it was my bad....
Just change the > 1 condition in FinalDDS to > 0, and also try removing the group by clause
on the final select.
BTW, do you want to...
February 11, 2009 at 6:47 am
Here is the T-SQL to get the list of jobs with TSQL subsystem tasks...
SELECTj.name AS JobName, js.step_name AS StepName, js.database_name AS DatabaseName
FROMmsdb.dbo.sysjobs j
INNER JOIN msdb.dbo.sysjobsteps js ON j.job_id = js.job_id
WHEREjs.subsystem...
February 11, 2009 at 6:35 am
cam (2/10/2009)
hIThank you, could you please guide me to some software that could alternatively be used?
As of now, I don't know of such software.., but my best pal "Google" does...
February 10, 2009 at 10:12 am
Since you are using the GROUP BY clause, it means you need to include non-aggregated columns in that clause....
GROUP BY DDS, ClearedDate, TotalCleared WITH ROLLUP
February 10, 2009 at 10:08 am
OK, got it this time, check this registry entry "HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL"
EDIT:
And also, there are many free tools available that does this.
February 10, 2009 at 8:07 am
Cross check the data inserted into the table (i.e without FK), that this data is not violating the FK constraint...
February 10, 2009 at 7:50 am
Can you check whether the SQL Server exists?
Does the connection is blocked by a firewall?
Is SQL Server listening on some other port?
Verify the Connection String used in VB.Net code...
February 10, 2009 at 7:46 am
cam (2/10/2009)
I should probably add, that normally (I guess) you make a .dtsConfig file for each of the servers/machines/pc's that you want to run the SSIS package on.
Normally, we...
February 10, 2009 at 7:41 am
josephptran2002 (2/10/2009)
how are you? I'm sorry to take me this long to say thank you very much for your helps. because i broke my arm, i will try your codes....
February 10, 2009 at 7:15 am
I guess it has to do with some permissions on file, though you said it can access the schema.
Try granting the read/write access to the folder to the SQL service...
February 10, 2009 at 7:06 am
I don't think you have read the entire article, it clearly has an example of running totals with pre-available scripts. Please spare some time in reading the article &...
February 10, 2009 at 5:16 am
Viewing 15 posts - 526 through 540 (of 1,124 total)