| | Rating Thread /
Thread Starter | Last Post  | Replies | Views |
 |  | Good afternoon, all. Whenever I try to use Query | Display Estimated
Execution Plan in SQL Studio on any non-trivial query, I get this...
=?Utf-8?B?Sm9uT2ZBbGxUcmFkZXM=?=
|
08-06-2007 09:22 PM
Roy Harvey  | 2 | 64 |
 | | I finally got my other problems corrected, but a new one has popped up.
SSMS is installed, but does not show up in the START menu in the SQL...
GeekBoy
|
08-06-2007 04:11 PM
GeekBoy | 22 | 113 |
| | | Windows 2000, SQL server 2000
Is there a way to schedule a SQL server job to only run on M-F. I see
where I can schedule a "daily" job, or weekly...
Den
|
08-06-2007 03:02 PM
Aaron Bertrand [SQL Server MVP] | 6 | 51 |
| | | Hi. In SQl Server 2000 Enterprise Manager there was a very useful 'Taskpad'
facility that gave you an overview of a database. Is there anything like...
=?Utf-8?B?WWFIb3puYQ==?=
|
08-06-2007 08:23 AM
Tibor Karaszi | 12 | 87 |
| | | Dear ladies and gentlemen,
Upscene Productions is happy to announce the major
version of their test data generator tool:
"Advanced Data Generator 2"...
Martijn Tonies
|
08-06-2007 06:43 AM
Martijn Tonies | 0 | 44 |
| | | So for at least a month now I've been able to reproduce, pretty much at will,
a blue-screen bugcheck from within the sql workbench.
This happens...
=?Utf-8?B?QW5kcmV3IEhvbGxhbW9u?=
|
08-05-2007 10:27 PM
Sue Hoegemeier | 10 | 151 |
| | | I am a simple home user, I do not develop nor do I extract information for
analysis or whatever - do I still need SQL? Can I just remove SQL?
=?Utf-8?B?RGVuaXMgQXJpYWw=?=
|
08-04-2007 06:51 AM
Hugo Kornelis | 2 | 53 |
| | | Anyone know if there if there is a tool visual tool for MS SQL server 2005?
Something to manage data and tables within the database without having...
GeekBoy
|
08-03-2007 09:30 PM
GeekBoy | 16 | 88 |
| | | Does anyone know if there is a way to group user databases in Management
Studio the same way system databases are grouped within a folder? We...
=?Utf-8?B?Y2hyaXNi?=
|
08-03-2007 10:38 AM
Aaron Bertrand [SQL Server MVP] | 2 | 53 |
| | | It's a wonderful convenience for me to open up a Mgmt Studio project
and have all the windows come up that I had when I closed it. I tried
saving...
James
|
08-03-2007 09:00 AM
James | 0 | 63 |
| | | Hi,
I am using SQL Server Management Studio to manage both 2000 and 2005
servers. I would like to see a Job Activity Monitor window that covers...
=?Utf-8?B?UGF1bA==?=
|
08-03-2007 07:53 AM
Andrew J. Kelly | 4 | 56 |
| | | I'm experiencing this error when I attempt to expand the database node in Sql
Server Management Studio Express (installed on Server 2003,...
=?Utf-8?B?U3RlcGhlbg==?=
|
08-02-2007 02:36 PM
=?Utf-8?B?U3RlcGhlbg==?= | 2 | 41 |
| | | I have a curious problem with profiler (version 9.00.3042.00) in that when I
select the save to file option the selection immediately resets back...
=?Utf-8?B?TXIgTWFqb3IgVGhvcmJ1cm4=?=
|
08-01-2007 06:12 AM
=?Utf-8?B?TXIgTWFqb3IgVGhvcmJ1cm4=?= | 0 | 50 |
| | | We have an XP workstation containing a very important MSDE-based
application. Its MSDE database isn't likely to change for quite a
while.
The app...
tlyczko
|
07-29-2007 06:49 PM
Sue Hoegemeier | 10 | 86 |
| | | I need to convert SQL Server 6.5 data to SQL Server 2005 (Express). How do I
do that? Where do I get the necessary tools?
=?Utf-8?B?R3VkbmkgRy4gU2lndXJkc3Nvbg==?=
|
07-27-2007 04:50 AM
Erland Sommarskog | 2 | 54 |
| | | what default sample does SQL 2000 use when you issue an Update Statistics
command? How do I set it so that SQL will use the same sample all the...
=?Utf-8?B?bXJkag==?=
|
07-26-2007 08:14 PM
Sue Hoegemeier | 10 | 88 |
| | | I'm hoping someone here will be able to tell me what's going on. Here's
what's happening:
On my old laptop, I had SQL Server Enterprise Manager...
Robert Morley
|
07-26-2007 05:50 PM
Robert Morley | 28 | 126 |
| | | I have a client that installed SQL Server Enterprise Edition for the Engine
but already had SSMS Express Edition installed.
Now I need to uninstall...
=?Utf-8?B?VGhvbQ==?=
|
07-24-2007 05:30 PM
Erland Sommarskog | 2 | 59 |
| | | Hi all,
By mistake I added the "Next topic" and "Previous topic" twice in the
toolbar and I don't know how to remove/delete one of them. To add the...
=?Utf-8?B?Sm9kaWU=?=
|
07-24-2007 04:56 PM
=?Utf-8?B?Sm9kaWU=?= | 0 | 59 |
| | | The Security Catalyst had an interesting post last week, The
Psychology of Fraud -Revisited.
In the post, Sarbanes-Oxley auditors are criticized for...
jmichaud@ecora.com
|
07-23-2007 01:30 PM
Geoff N. Hiten | 2 | 45 |
| | | Hi,
Having upgraded to SQL 2005 client from SQL 2000 I'm now using the new
Management Studio tool to view/edit/amend scripts, etc. I've noticed
that... |
07-23-2007 09:20 AM | 0 | 48 |
| | | i have sql server 2005 express
and i cant find the sql server agent that was like in sql server 2000
why is that? where are the jobs?
thnaks i...
=?Utf-8?B?cGVsZWdrMQ==?=
|
07-22-2007 04:08 PM
=?Utf-8?B?cGVsZWdrMQ==?= | 0 | 50 |
| | | Environment
OS: W2K3 SP2 R2 x64 both Ent & Std ed
SQL: 2005 SP2 x64 Ent & Std ed
Services logons: SQL Server & SQL Server Agent as...
=?Utf-8?B?ZGF2aXN3bHA=?=
|
07-21-2007 11:52 AM
=?Utf-8?B?ZGF2aXN3bHA=?= | 0 | 46 |
| | | The sql server 2005 managment studio that I work with does not recognize a
-- as a comment when I am executing a script when the -- starts in column...
=?Utf-8?B?V2VuZHkgRWxpemFiZXRo?=
|
07-21-2007 02:18 AM
Tibor Karaszi | 2 | 45 |
| | | I'm hoping that someone can help me clarify some questions I have
regarding BACKUP and how files are replaced. Ideally I want to perform
backups to a...
Pete
|
07-19-2007 04:04 PM
Tibor Karaszi | 8 | 63 |
| | | I am trying to print a report from Reporting Services in C# code. Is this
possible?
=?Utf-8?B?RGFu?=
|
07-19-2007 01:23 AM
Pawel Potasinski | 2 | 53 |
| | | We use diagrams extensively in SQL Server 2000 (have yet to upgrade to
2005). At some point in time, I must have changed a 'snap to grid'...
Andrew Hilton
|
07-18-2007 08:07 PM
Andrew Hilton | 0 | 48 |
| | | Can i use SQL Server 2005 Express Management studio to connect to a SQL
Server 2000 Instance.
=?Utf-8?B?U3VyZXNo?=
|
07-18-2007 05:23 AM
Siwy Bober | 4 | 48 |
| | | I need to attach SQL 2005 DB to SQL 2000 server.
I cannot be sure, but I think I did it before in Entreprise Manager. I also
found an answer to my...
vovan
|
07-16-2007 09:13 PM
Andrew J. Kelly | 2 | 46 |
| | | Hi,
There seems to be a problem with SQL Profiler 2005 recently. It was working
till date and recently it is not starting up all of a sudden. I get...
=?Utf-8?B?U3JpcmFtIE1hbGxhanlvc3VsYQ==?=
|
07-13-2007 03:00 PM
=?Utf-8?B?TW9oaXQgSy4gR3VwdGE=?= | 2 | 59 |
| | | I just started configuring this in 2005, I only recently configured it in
2000. It seems like in 2000 you can assign different schedules for...
=?Utf-8?B?TWljaGVsbGU=?=
|
07-12-2007 01:32 PM
=?Utf-8?B?TWljaGVsbGU=?= | 0 | 42 |
| | | Hi,
With earlier versions of SQL server and Enterprise Manager it was easy to
see which sql server agent jobs have failed - you could just look down...
=?Utf-8?B?Sm9obiBXYWxrZXI=?=
|
07-12-2007 09:34 AM
=?Utf-8?B?Sm9obiBXYWxrZXI=?= | 4 | 41 |
| | | Our IT production support team stores miscellaneous SQL scripts for support
items on a SharePoint server (WSS 3). However, to edit these scripts,...
Dave Slinn
|
07-11-2007 09:35 PM
Charles Wang[MSFT] | 2 | 45 |
| | | I want to be able to change the value of two tables where the key in one
table is a key in another table. There is a check constraint set on the...
=?Utf-8?B?V2VuZHkgRWxpemFiZXRo?=
|
07-11-2007 04:18 PM
Erland Sommarskog | 2 | 47 |
| | | Hi experts,
is there any external tool or feature within SQL Server 2005, which
enables a searchable documentation of schemas?
What I would like to...
send.me.all.email@googlemail.com
|
07-11-2007 09:29 AM
TheSQLGuru | 4 | 48 |
| | | Hi,
We have SQL Server 2000 with about 10 databases.
My task is to look through all the stored procedures and user-defined
functions in all the...
=?Utf-8?B?Sm9obiBXYWxrZXI=?=
|
07-10-2007 08:09 AM
Roy Harvey | 12 | 71 |
| | | We have a SQL Server 2005 SP2 server that also functions as a
secondary domain controller in active directory. Everything works
extremely well...
Matt Ziegler
|
07-10-2007 07:18 AM
JPD | 2 | 48 |
| | | Where are the Icons that are used in SQL Management Studio located?
Thanks,
Don
=?Utf-8?B?RG9uYWxkIEh1cmxleQ==?=
|
07-10-2007 06:28 AM
=?Utf-8?B?RG9uYWxkIEh1cmxleQ==?= | 0 | 52 |
| | | Hi,
I notice that a few third party SQL Server tool developers (RedGate
for example) have started to sell utilities that appear as add-ins
to
SQL...
matt_randle@yahoo.com
|
07-09-2007 06:00 AM
matt_randle@yahoo.com | 6 | 51 |
| | | I'm running on a dual xeon development box.
Quite often, if I have Visual Studio 2005 up, the Microsoft SQL Server Mangement
Studio will run very...
Les Caudle
|
07-09-2007 05:23 AM
Wei Lu [MSFT] | 12 | 70 |
| | | I have a production job that is killing BCP.... If I change the dates to
2/28/08, the file processes just fine. Here is the error message .......
greg may
|
07-05-2007 06:22 PM
greg may | 4 | 59 |
| | | We're running some 2000 and some 2005 servers. We have a home-grown system
that kind of consolidates problems (all admin stuff) and uses...
=?Utf-8?B?TWljaGVsbGU=?=
|
07-05-2007 11:06 AM
=?Utf-8?B?TWljaGVsbGU=?= | 4 | 49 |
| | | Hi,
Who's able to help me out on this?
We have created a job in SQL Server 2005 and if we click on start we get
above mentioned error. The Job has...
=?Utf-8?B?U1FMLUhlcmJpZQ==?=
|
07-04-2007 10:21 AM
Andrew J. Kelly | 6 | 48 |
| | | I`m looking for programs, that could test response from SQL serve db.
I have DB, but it is operational, and I do not like to make any changes on
that...
=?Utf-8?B?TXIuQg==?=
|
07-03-2007 09:41 PM
Greg O | 6 | 85 |
| | | Hi
I would like to compare efficiency of my queries before update and
after it, so I created a Profiler trace using TSQL_Replay template.
Then I...
Piotrek
|
07-03-2007 09:15 AM
Piotrek | 0 | 53 |
| | | What date constants are available for entering today's date in a
datetime column after using the Open Table command within SSMS? I
have tried...
pwc
|
07-01-2007 06:32 AM
Erland Sommarskog | 2 | 56 |
| | | I basically want to 'step through' t-sql 2000 statements and I have tried
the several methods. Can you tell me what would you suggest? I have...
=?Utf-8?B?V2VuZHkgRWxpemFiZXRo?=
|
06-29-2007 04:51 PM
Erland Sommarskog | 2 | 44 |
| | | SQL2005, sp2
Is there a way I can turn off the "use db" statement that shows up when I
modify a stored proc?
Thanks, Andre
Andre
|
06-28-2007 04:45 PM
Erland Sommarskog | 2 | 46 |
| | | The DB Engine Tuning Advisor won't analyze my sprocs with temp tables,
always giving the error:
All the events in the workload were ignored due to...
Andre
|
06-28-2007 04:13 PM
Andre | 4 | 51 |
| | | I am running a query that sometimes returns a cellset, and sometimes it
doesn't (depends on the dimension security). For users who do not...
=?Utf-8?B?Sm9obkhlbm5lc2V5?=
|
06-28-2007 04:10 PM
=?Utf-8?B?Sm9obkhlbm5lc2V5?= | 0 | 54 |
