Hi Noel, quote: Don't see the problem here... If the Manager gets deleted, so would the ID, so there is no difference in it. there is a huge problem!!! First thing to do when dealing with managers is to give them some nicely colored PPT slides, you then might be able to keep them out […]
2003-07-17
Makes sense, thanks. I guess this would also explain the tempdb Transaction Log 'hangover' I've got, almost .5 GB of Used space that won't release. Now I can be certain it is the unfinished transaction I killed about halfway through the Sort. Total table size is 550 MB. I'll consider restarting the instance this weekend […]
2003-07-17
1 reads
The guest user allows a login without a user account in database to access that database. The login obtains the database permissions granted to this 'guest' account.
2003-07-16
2003-07-16
From the OpenHack 4 config and with confirmation of Richard Waymire at Microsoft. quote: I only know of ONE - the table master..spt_server_info This isn't one. It's revoked from public. quote: But I think I'm wrong about this, because if I was right, you could just run DENY SELECT ON SPT_SERVER_INFO TO GUEST in the […]
2003-07-16
Frank, thanks for all the help. I think my mail is configured but I will search instead. BOL = Books Online? I will post any good URLs I find in here.
2003-07-15
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2003-07-14
Try: if (dob IS NULL) BEGIN insert from [tablename] END else BEGIN insert * from [tablename] END Although in this case you don't need the BEGIN and END and there is only a single line of code in the IF statement. -Ed
2003-07-14
Hi. Just out of curiosity, I would like a clarification of 'You need to have permissions to any database on the server.' Does that mean you need to have access to ALL DBs or you need access to AT LEAST one DB? If it is the later, I would say it is hard to execute […]
2003-07-14
Ok, I created a new database called TestDatabase. In this I have a Table called Table1 and a field called test. I used the sample code: <% set cnn = server.createobject("ADODB.Connection") cnn.open "PROVIDER=SQLOLEDB;DATA SOURCE=sqlservername;UID=username;PWD=password;DATABASE=databasename " %> to connect to my database. I haven't received any errors yet but I havent tried to manipulate the database […]
2003-07-13
1 reads
By Rob Sewell
The Social Web Foundation is aiming to grow the fediverse and make the social...
By Steve Jones
A customer recently wanted to know if any of their instances were too old...
A reader of one of my previous posts pointed out that the legend order...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers