Viewing 15 posts - 3,946 through 3,960 (of 7,504 total)
I still miss the most obvious question ....
Does your data contain NULL and how does that relate to the results you expect from your queries?
FYI
http://www.sqlservercentral.com/articles/Basic+Querying/understandingthedifferencebetweenisnull/871/
http://www.sqlservercentral.com/articles/Advanced+Querying/2829/
http://www.sqlservercentral.com/articles/Advanced+Querying/gotchasqlaggregatefunctionsandnull/1947/
http://www.sqlservercentral.com/articles/Miscellaneous/nullfunctionsarentthosemeetings/1313/
March 4, 2009 at 1:55 pm
- has your sproc been granted external access ?
- does the service account have delete authority on that unc pointed fileshare ?
You might as well use a vbscript in a...
March 4, 2009 at 1:49 pm
You cannot force an isolation level (except when you put a filegroup or db in read only mode).
Putting everything is serializable isolation level will raise the risk of lock timeouts...
March 4, 2009 at 1:41 pm
p.description,isnull(s.rankcode,9999) as rankcode,
...
order by S.rankcode, p.description, m.matnr
...
Removing the S. in s.rankcode made it work. I understand why. But i don't understand why it
I would suspect the collation...
March 4, 2009 at 1:35 pm
AShehzad (3/2/2009)
March 2, 2009 at 4:31 am
GilaMonster (3/2/2009)
ALZDBA (3/2/2009)
If there is more than one concurrent "#temp" object, sqlserver will add stuff to the object name to make it unique.
SQL will always add a prefix, whether it's...
March 2, 2009 at 4:09 am
Keep in mind tempdb is on of SQLserver's working horses !
If you ensist on quering the catalog for temp objects,
keep in mind SQLserver names them as it pleases.
If there is...
March 2, 2009 at 3:18 am
Column names are a fixed item in sql, so
to do that you would have to generate dynamic sql:crazy:
or use a form of pivot function.
Declare @sqlstmt as varchar(500)
Set @sqlstmt = 'select...
March 1, 2009 at 7:27 am
has the clr proc been granted external access ?
Personally, I wouldn't put that kind of stuff in a trigger.
A trigger is in process context, so if the trigger fails, the...
March 1, 2009 at 7:15 am
SSMS / database / backup GUI presents the last known filename that has been used to create a backup.
As you've stated, what's in an extention. It can be anything.
If you...
March 1, 2009 at 7:10 am
Sqlserver raises events when a queue get disabled.
Check out "CREATE EVENT NOTIFICATION" in books online !
February 28, 2009 at 6:04 am
- tempdb is re-created every time sqlserver gets started !
- there is no need to grant on tempdb !
everyone is allowed to create #-tables !
February 28, 2009 at 6:00 am
Check out create database or Alter database in books online !
e.g from BOL
ALTER DATABASE AdventureWorks
MODIFY FILE
(NAME = test1dat3,
SIZE = 20MB);
February 28, 2009 at 5:54 am
Here's another forum thread stating some sequences and actions:
http://www.sqlservercentral.com/Forums/Topic655130-146-1.aspx
February 27, 2009 at 1:08 pm
Keep in mind you also need to backup master and msdb !
just put the script in a file e.g. fullsystembackup.sql
Then create a SQLExpress_fullsystembackup.cmd file containing :
cd /d yourdrive:\thescriptpath
sqlcmd -S...
February 27, 2009 at 12:57 pm
Viewing 15 posts - 3,946 through 3,960 (of 7,504 total)