Best practise is to configure SCCM DB server in Windows only mode, but you can change it to mixed mode.

If your sys admins dont want to change the authentication mode,...

This is a Microsoft SQL server forum, not a MySQL forum, you might be best using a dedicated MySQL forum.

But a quick google search for "export mysql db to file"...

Does the table exist?

Do you have permissions to the table?

What is your user accounts default schema? If it is different than that of the table, you will need to...

No you dont have to specify an else to do nothing

declare @i int = 1

if @i = 0

begin

select 0

end

Will just result in a "Command(s) completed successfully" message as it has...

ssarria (11/27/2012)

---

Hi Pavan,

The idea is to create a back up of the database on a flat file. It could be by tables.though

I did use mysql workbench to update an existing...

Two ways,

Dont insert a value into the identity column of the destination

or

Add the below to the query

SET IDENTITY_INSERT tblTransactions ON

I believe the only way to do it is with the LOOKUP expression, so you will need to create two data sets in your report then use a lookup expression...

Column selectivity has a huge part to play in a statement as it tells the query optimiser what to do.

If you could follow the link in my signature on posting...

yes if the service is offline the files are not locked and can be deleted.

Now how active is the server?

Default trace will only store so much information before it rolls...

Yes I would as Gail has mentioned that the documentation on MSDN is incorrect, so anything which says its in seconds is incorrect.

Yes I would as Gail has mentioned that the documentation on MSDN is incorrect, so anything which says its in seconds is incorrect.

Yes, if the table already exists then add an INSERT INTO command below the CTE declaration above the SELECT.

If the table doesnt exist, add the INTO clause above the FROM.

WITH...

Yes, if the table already exists then add an INSERT INTO command below the CTE declaration above the SELECT.

If the table doesnt exist, add the INTO clause above the FROM.

WITH...

I stand corrected.

From MSDN

http://msdn.microsoft.com/en-us/library/ms188603(v=SQL.105).aspx