Deadlock Graph: TextData xml - interpreting
Fri, 19 Jun 2009 15:55:38 -0400
So I used Profiler to obtain the Deadlock Graph and saved the trace both to
an xml file and to a table. Rather than having to slog thru all this
information, there are over 700 rows, is there a way to extract useful
information either from the xml file or from the TextData column in the
saved table?
TIA
...
|
REport BUilder 2.0 - Chart
Wed, 17 Jun 2009 02:34:42 GMT
How to create a single bar chart by using the report builder 2.0??...IM new
to report builder2.0 , so i would like to know more about report builder 2.0
in chart!!..ur info is much appreciated..!!
...
|
Profiler: Deadlock Graph - Associated ObjectID
Mon, 15 Jun 2009 12:59:27 -0400
I'm sure I asked this question on here before and pretty sure I got a very
useful answer to my question, however, being the dufus I am I didn't save
the answer and have long since forgotten what it was. So here I am again,
encamped upon your floor to ask once more what is the Associated ObjectaID
that gets d ...
|
"loading of the imagelist did not succeed." error in SSMS 2005
Wed, 10 Jun 2009 01:37:01 -0700
Hi,
I recently upgraded my workstation with SQL2005 to SP3. Since then it often
happens that I get an "loading of the imagelist did not succeed." error when
I want to view e.g. the server properties or some job properties, anyway, it
allways occurs when it results in a new window being opened.
Any clues? ...
|
Sql problem
Mon, 08 Jun 2009 22:58:30 -0700
The backup set holds a backup of a database other than the existing
database
*** Sent via Developersdex http://www.developersdex.com *** ...
|
Backup database
Mon, 8 Jun 2009 22:18:27 +0200
Hello,
I need to backup SQL server data bases. I plan to use Enterprise manager to
plan regular backup.
There is many databases in the database folder. Can I plan backup only for
master database to backup all databases, or it is necessary to plan backup
for each database in the folder separately?
Thank You ...
|
Enterprise Manager displays nvarchar as <binary>
Thu, 4 Jun 2009 09:09:01 -0700
Hi everyone
I had no problems with Enterprise Manager until recently.
At this moment the content of NVARCHAR columns is displayes as <binary>.
If the datatype is changed to varchar the contents is displayed correctly.
The data content is also shown correctly from SQL Query Analyzer but VIEW
and TABLE brows ...
|
|
|
Appending Data via BCP
Thu, 4 Jun 2009 08:17:01 -0700
Hello all,
I append/import data from a csv file into a table in SQL Server via BCP.
The twist is the table that I append into has two extra columns than the
number of columns in the csv file. I use the following code to import the
data, and I got an error and it would not import.
bcp myDB.dbo.my_Tabl ...
|
How to manage the transaction log
Wed, 3 Jun 2009 15:54:01 -0700
Hello all,
How do I manage the transaction log file (ldf) so that it would not keep
growing and so that I can import the data into the database?
I am using the SQL Server 2005 Express. All my data are in csv files, and I
import them into SQL via bcp.
Initially, I set the Autogrowth of log file unrest ...
|
VS 2005 (BIDS) deploys the wrong data source connection string
Wed, 3 Jun 2009 11:01:01 -0700
Sorry, don't know if this is the correct forum for this thread, please
suggest another if not....
In a cube project you have a Data Source that feeds a data source view that
defines the data objects used to build a cube.
You want to CHANGE the data source connection string based on where you are
deploy ...
|
