ohpenot (2/19/2013)

---

Hi Lowel,

Have the same problem "access denied" when trying to exec "xp_cmd". Except that i am on windows seven. The company isntalled sql express on my machine to start...

True but its only half of the puzzle,...

.net 2.0 is Required for both installation...

Stefan Krzywicki (2/15/2013)

---

Why do we still use ' as a text indicator in databases? Why haven't we (meaning people who design systems) created a unique symbol that we can...

prathibha_aviator (2/15/2013)

---

Lowell,

Thankyou for ur response.. It worked so well.. I just couldnt believe that my problem resolves in no tym... 🙂 Would you also help me Now if i want...

from another post very similar to yours, i created this trigger to create a role if it doesn't exist;

it SEEMS to work in my limited testing then and now:

note this...

ok, in that case, it might be that the tempdb is running out of space or something for the import wizards process?

i'd still recommend backup and resotre over the copy...

you cannot copy the mdf/ldf data files themselves unless the sql server is actually stopped; otherwise you get corrupted files.

you cannot replace a server's existing databases if the server is...

and a simple cross apply example:

with myCTE(val)

AS

(

SELECT 'Heavy rains that fell across the Upper Mississipp' UNION ALL

SELECT 'i River Basin in the summer of 2007 were responsi' UNION ALL

SELECT 'ble...

there are multiple .NET frameworks, and they are side by side installations, not upgrades from previous; so you need each version to support various functionality that use each framework.

my developer...

this book has a few pages on renaming both the sa/administrator login and the guest account:

http://books.google.com/books?id=MsZWztjVbMcC&pg=PA162&lpg=PA162&dq=sql+server+rename+the+guest+account&source=bl&ots=60hO6CtY5a&sig=-_fsIZ9dfCMRyeuU-lQ8xVEf7q0&hl=en&sa=X&ei=ZF4eUZirA5Ho9gSah4GgDg&ved=0CFQQ6AEwBQ#v=onepage&q=sql%20server%20rename%20the%20guest%20account&f=false

take a look at this thread; it can help you find the ascii code of the unseen character(s)

;

from there, you can decide whether you want to replace it or whatever:

there's...

take a look at this thread; it can help you find the ascii code of the unseen character(s)

;

from there, you can decide whether you want to replace it or whatever:

there's...

another possibility that seems fast and easy would be to select one days data into a new table, do sp_spaceused , and then drop that table.

then you could get the...

Kwisatz78 (2/14/2013)

---

Hi - I have got the networks guys to monitor blocked traffic on the firewalls and there is none for the defined port from my workstation. I know...