September 9th, 2008
msquared (Administrator)
|
Error 262 create database
nickbeds (nickbeds@gmail.com) writes:
Do you have any particular reason to expect to be able to create
databases?
If you try to do this on a... more »
|
|
How to control number of users in a database?
1 Reply |
Posted by: kai
| Last post by Erland Sommarskog, Today
kai (kailiang@bellsouth.net) writes:
If you actually mean *database* I don't think there is a foolproof
way to do this. You could set up a logon... more »
|
|
SSMS - setting root of Object Explorer
On 3 Oct, 22:24, Erland Sommarskog <esq...@sommarskog.sewrote:
Done. Thanks again. more »
|
|
How do i write Set based queries and avoid a cursor?
On Oct 4, 5:02 pm, DA Morgan <damor...@psoug.orgwrote:
I am generally not very excited about sewer gardens, but I do enjoy
several other types of... more »
|
|
[Newbie Question] SSMS indexes
Under SSMS where can one find the list of indices?
Indexes are dependent on a specific table so you need to first expand the
desired table node,... more »
|
|
Stored procedure
"A problem well stated is a problem half solved." -- Charles F.
Kettering
Please post DDL, so that people do not have to guess what the... more »
|
|
T-SQL
(ventalinks@nospammers.com) writes:
Before you do anything else, you should speak with your DBA. Maybe this
is just a case of malconfiguration. May... more »
|
|
SQLSVR 2005 SP2 / Shrink data file will not work
Major Drake (major.drake@pp.inet.fi.HALOOOOOOO.fi) writes:
Page and extent deallocation can be deferred for large deletes, so that they
are not... more »
|
|
Accessing the call stack via TSQL
1 Reply |
Posted by: michael
| Last post by Erland Sommarskog, 8 days ago
michael (michael.atherton@gmail.com) writes:
Nope. But I encourage you to go... more »
|
|
Application Roles and SQL Server 2005 - DDL?
2 Replies |
Posted by: JimL
| Last post by Erland Sommarskog, 8 days ago
JimL (jmlawton@gmail.com) writes:
Not sure that I understand. This worked fine for me on SQL 2005:
create application role approlle with password =... more »
|
|
Import/Export Wizard
1 Reply |
Posted by: DaveL
| Last post by Plamen Ratchev, 8 days ago
When you save package to the Server it is saved in the 'msdb'... more »
|
|
SQL Server Management Studio question
Your data is encrypted.
http://dotnetslackers.com/articles/sql/IntroductionToSQLServerEncryptionAndSymmetricKeyEncryptionTutorial.aspx
-Eric Isaacs more »
|
|
Performance/stability issues
(time_error@hotmail.com) writes:
In addition to what Dan and Roy said, the Profiler is a good tool to
track down performance issues. You can set up... more »
|
|
easily repeatable index corruption in SQL Server 2000 (8.00.2050,post-sp4)
(brian.j.parker@gmail.com) writes:
I was able to reproduce the error with SQL 2000 SP4. I did not happen
on SQL 2005 SP2. I don't know if there is a... more »
|
|
How To Look At Chronological Series To Find the First Values GreaterThan Zero?
Thanks Erland, changing the SELECT from '17530101' to '19000101' did
the trick and the code works now. Serious appreciated.
All best,
Peter more »
|
|
DateDiff Calculation - odd results
I think its the datatypes too. The results I receive below work fine
with your update statement in SQL Server 2005...
CREATE TABLE... more »
|
|
SQL 2005 management studio vs SQL 2008 express
Alex Pavluck (apavluck@gmail.com) writes:
I believe that the Table Designer and the Query Designer are both
included in the SQL 2008 Express... more »
|
|
set default value
what is the syntex for changing default value.
You first need the constraint name. This can be found with:
EXEC sp_helpconstraint 'dbo.'test'
You... more »
|
|
Inconsistent results for SELECT SUM(<<real field>>) ...
1 Reply |
Posted by: rnhuch
| Last post by Plamen Ratchev, 12 days ago
The FLOAT/REAL data type is approximate, and as such not all values in
the data type range can be represented exactly.
Interesting readings on the... more »
|
|
Services not listed on Configuration Manager screen?
4 Replies |
Posted by: aj
| Last post by Erland Sommarskog, 14 days ago
aj (ronald@mcdonalds.com) writes:
3050? That's a very odd version!
I don't remember under which build number SP2 was originally released as,
but... more »
|
|
Interview type Question
1 Reply |
Posted by: raja
| Last post by Robert Klemme, 14 days ago
On 24.09.2008 15:01, raja wrote:
Now what: did he ask you about Oracle or SQL Server? This is
ridiculous. Do your homework yourself!
robert more »
|
|
SQL Express on dual processor server?
YEs, it will install. As you suspect, it is just limited to 1cpu/1GB memory.
--
Tibor Karaszi, SQL Server... more »
|
|
Connection issue when trying to connect MS SQL SERVER from Linux
3 Replies |
Posted by: SRK
| Last post by Erland Sommarskog, 14 days ago
SRK (kumarsr@gmail.com) writes:
And you try to connect to the server you intend to? I don't see any server
specification in your command line.
Does... more »
|
|
Trigger to Update Fields of Inserted Record
>Wrong. T-SQL has both INSTEAD OF and AFTER triggers. <<
To quote myself:
"In Standard SQL, they can be BEFORE or AFTER triggers, while T-SQL
only... more »
|
|
I need a little cursor help
4 Replies |
Posted by: CK
| Last post by CK, 15 days ago
How do I write a set based query? I have a groupSets table with fields
setId, idField, datasource, nameField, prefix, active
Data:
1,someIDfield,... more »
|
|
