Oh well. I thought it was worth checking, thanks for clarifying. So much for applying a patch in case you were in fact hitting a SQL2000 DB. Follow the advice...

Michael L John (3/21/2013)

---

I stand corrected.

BUT I also stand by the statement because unfortunately poor security seems to be the norm. It seems as if DBA's are so busy with...

casanova (3/24/2013)

---

Hi Experts,

Can anyone explain me step by step how to import excel into SQL server database using SSIS dynamically and automate it (run the package on weekly basis)

Here are...

The best way I have found to do this is using WMI but not from within T-SQL, from a PowerShell script. Use Get-WmiObject to read from class Win32_LogicalDisk against Windows...

Database Users > guest User

You can think of...

GilaMonster (3/24/2013)

---

DTS runs fine on SQL 2005 and 2008. Deprecated,...

DTS? What version of SQL Server are you on?

SELECT SERVERPROPERTY('Edition') AS Edition,

SERVERPROPERTY('ProductVersion') AS ProductVersion,

...

Right, BULK INSERT, or sp_OA, or SQLCLR, and maybe some other things that could be initiated from the server that I didn't bother mentioning. I still disagree with you on...

Banana-823045 (3/20/2013)

---

I'm curious if anyone else has figured out a good system for performing analysis on a query that may have multiple CTEs stacked. While some problems can be resolved...

The image did not post correctly. Can you please try posting it again?

These may help:

Iterate Over Databases Using SSIS – Part 1[/url]

Iterate Over Databases Using SSIS – Part 2[/url]

Here is how you would do it using SSIS:

Iterate Over Databases Using SSIS – Part 2[/url]

mhmdsow (3/23/2013)

---

hy !

There is my view

mvtDtate mvtMouvementDebCred TypemvtMouvementDebCred

1/1/2013 154 000 D

2/1/2013 210 000 C

3/1/2013 654 012 D

4/1/2013 213 000 564 C

After more essay : And I want a result as...

Catch-all queries by Gail Shaw[/url]

gantavasu (3/23/2013)

---

Here i have configured the mirroring. after that i want to add the data file to primary.

can we add the data file?

if we add is there any impact on...