Viewing 15 posts - 3,946 through 3,960 (of 7,503 total)
- 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
As stated above, you can use management studio to perform the action.
However, more interesting is to let SSMS generate the SQL to complete the action.
Doing so, you'll see SQLserver encapsulates...
February 27, 2009 at 12:49 pm
Viewing 15 posts - 3,946 through 3,960 (of 7,503 total)