We have a space issue in drive. No space for backups.

I could see the network drive in MyComputer. How can I know whether it is UNC network drive.

I tried...

Yeah I have tested DBMail without the attachment. Every thing looks good.

THing is Client server is...

No error. I could see the mail in sent box.But client is saying he is not getting any email or attachments.

Client also they tested several files with

large attachments...

Thanks for your reply. Can you please explain in details, what transformation need to...

I created below script and added to source in SSIS package, destination I have taken csv file.

when I execute the package I am getting below error.

Column 'OfficePhone' cannot convert between...

I am getting empty space if I use below query

USE MYDB;

GO

select UserName, ISNULL(NULL, '') AS 'UserID'

FROM Tablename;

GO

I am getting 0 if I use below query

USE MYDB;

GO

select UserName, ISNULL(Userid, '')...

Hi Jeff, Thanks for your reply.

I am getting empty space by using below query. Please correct me if I am wrong.

USE MYDB;

GO

select UserName, ISNULL(NULL, '') AS 'UserID'

FROM Tablename;

GO

Jeff...

I used below query

USE dbname;

GO

select column1, column2, ISNULL(Column3, ' ') AS 'xxxx'

FROM Table1;

GO

column3 (FK, int, null)

Actually I need to export the data to excel file. Some the coulumns data have NULL values.

I have used ISNULL function and wrote a below T-SQL statement, but ...

Thanks for your replies.

I have successfully removed BUILTIN/Administrator after adding the group to SQL Login that used to administer the SQL Server.

Our server is SQL Server 2005 cluster server active/passive

What...

we want to remove the BUILTIN/Administrator after adding the Window group to SQL Logins to administer the SQL Server

D0 We need server failover/failback the cluster to ensure everything is working...

If I understood correct...

if we disable agent xps , only thing is SQL Agent node/group is not available in SSMS.

bUT agent service will run as normal, no issue with jobs.

Please...

Thank you very much.

2 more questions on sql security

1. Can we create a SQL login with out creating a windows user?

2. Can we create a DB user with out...

Thanks for your reply.

All applications (websites, windows services) use windows authentication...

Ed Zann (6/24/2010)

---

You can add a Script Component in your Data Flow to standardize your date format. Select a "Transformation" type. Select all of the input fields. ...