Viewing 15 posts - 18,931 through 18,945 (of 19,560 total)
Not exactly what you are looking for, but it is an alternative
http://www.bigresource.com/Tracker/Track-ms_sql-4rvFrQuz/
There is also the possibility of using SSIS to help send the proper codepage in your emails (through dbmail...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 3, 2009 at 9:17 pm
Yes. I have seen them try that with apps we bought being installed on my db servers. If you kick back hard enough, they will find a way...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 3, 2009 at 9:08 pm
In the Result Set tab set Result Name to 0 and select my System.Object variable (this will end up holding an ADO Recordset)
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 3, 2009 at 9:02 pm
Gus made a great suggestion. In addition to the book, install it, configure it and play with SSRS to get a better understanding.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 3, 2009 at 8:51 pm
What happens if you clean out your temp dirs?
What happens if you change the system temp variable to point to a different location?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 3, 2009 at 8:47 pm
Try this previous SSC thread
http://www.sqlservercentral.com/Forums/Topic417928-148-1.aspx
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 3, 2009 at 8:36 pm
In SSIS in your data flow task, add a data transformation task. Add a derived column.
http://msdn.microsoft.com/en-us/library/ms137630.aspx
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 3, 2009 at 8:34 pm
http://technet.microsoft.com/en-us/library/ms190273.aspx
Add column with default
USE AdventureWorks ;
GO
CREATE TABLE dbo.doc_exf ( column_a INT) ;
GO
INSERT INTO dbo.doc_exf VALUES (1) ;
GO
ALTER TABLE dbo.doc_exf
ADD AddDate smalldatetime NULL
CONSTRAINT AddDateDflt
DEFAULT GETDATE() WITH VALUES ;
GO
DROP TABLE...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 3, 2009 at 8:30 pm
Agreed, more details will yield a better answer. It will depend on accounting software and the software platform.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 3, 2009 at 12:00 pm
Your best bet will be to research and find a tool that can do schema comparisons between the two platforms (i.e. redgate has one that will compare SQL databases for...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 3, 2009 at 10:06 am
I would be extremely cautious of using that option. That option is for less than desirable configurations (i.e. quorum is on a shared resource with other drives) or for...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 3, 2009 at 9:57 am
As long as it is working, and the users are not overpermissioned - no reason that I can think of would make a "bad" approach.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 3, 2009 at 9:48 am
jez.lisle (12/3/2009)
Are you using the localsystem account for the database services?
Yes
When using the localsystem account for the database services, you will need to establish a certificate for the mirror in...
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 3, 2009 at 9:46 am
exorcism
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 3, 2009 at 9:41 am
doh - knew the right answer and clicked the wrong radial - pfpfpfpf
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 2, 2009 at 6:10 pm
Viewing 15 posts - 18,931 through 18,945 (of 19,560 total)