Mish-Mash of components
Fri, 3 Jul 2009 15:26:14 -0600
Hi,
Earlier today I was trying to install what I thought was SQL2005 Standard
64-bit but proved to be Enterprise Edition. I uninstalled but now I find I
have Standard Edition for the database engine but Enterprise Edition for the
Client Tools.
Anybody have any idea what is different about Enterprise Clie ...
|
Re: 0xx27 3084-5709 Jardim camburi apartamento apto 2 quartos 2qts em jardim camburi 1064463550
Thu, 2 Jul 2009 13:16:07 -0400
Frère Jacques, frère Jacques,
Dormez-vous? Dormez-vous?
Sonnez les matines! Sonnez les matines!
Ding, dang, dong. Ding, dang, dong.
"apartamento 3 quartos jardim camburi"
<apartamento3quartos@jardimcamburi-vitoria.com> wrote in message
news:%23XjHihz%23JHA.200@TK2MSFTNGP05.phx.gbl...
> Alugue seu Apartame ...
|
"A buffer overrun has occurred in SqlWb.exe..." with CROSS APPLY
Wed, 1 Jul 2009 07:07:06 -0700
I am getting an error in Microsoft SQL Server Management Studio when
designing a View on a Table. The table definition is:
CREATE TABLE [dbo].[Deals](
[recid] [int] IDENTITY(1,1) NOT NULL,
[xmlData] [xml] NOT NULL,
CONSTRAINT [PK_Deals] PRIMARY KEY CLUSTERED
(
[recid] ASC
)WITH (PAD_INDEX = OFF, STATISTIC ...
|
Performance problem
Tue, 30 Jun 2009 12:52:02 -0500
I have a problem with a production SQL box.
The problem is that once or twice a day the box is getting its processor
allocated for 100% for 10+ seconds.
How can I find out what command or something causes that?
Thanks
...
|
Problems running SQL scripts outside Management Studio
Mon, 29 Jun 2009 13:22:09 -0700
I have a script that populates some tables in a database. The script was
generated from Management Studio and includes some fields that are stored
"encrypted" by the application that created them.
When the scripts are executed via Management Studio the values are loaded
correctly. When they are executed v ...
|
SQL Server Management Studio Express
Fri, 26 Jun 2009 08:31:02 -0700
I have installed on a user the SQL Server Management Studio Express
console and they have full control , at least I think so to the a
specific database. The problem is that the user needs to be able to
click on the relationship diagram button in the console but it is greyed
out.
How c ...
|
How to bcp in fixed position data while skipping certain positions
Thu, 25 Jun 2009 10:01:01 -0700
I have a txt file I have to bcp in. The file contains fixed-position columns
of data but there is white-space in certain positions which I have to skip
over. So I need a way to provide start position for some columns. I do not
see a way to do this with format files.
Example
CCSBLLPLN 00001 0000 ...
|
|
|
>>Maintenance Plan - backup
Wed, 24 Jun 2009 17:50:01 -0700
Hi, sql2005 I used the Maintenance Plan wizard to set up a daily backup plan
to run after hours. So I now have a plan and sql server agent job; both
created by the wizard.
I right-click the job and select 'Start job at step...' and an error is
triggered. The log file viewer has the following message.
Una ...
|
Where is the Mgmt Studio ??
Wed, 24 Jun 2009 07:35:01 -0700
I have SQl2005 enterprize version that was installed "analytical"??
Here is what I got:
SQL Server 2005 --> Confiuration Tools --> SQL Server Configuration Manager
SQL Server
Error & Usage Reports
...
|
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
...
|
