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...

what does your connection string look like?

are you putting servername-comma-port in the connection string? i know it's common for people to use a semicolon by mistake.

for example

Private Const...

uggh; looks like you are doing something in a trigger(inserting/updating into another server?) that should be done in a service broker, or a schedule job that would do...

I'd blame the application that might be inserting rows into the table; chances are the code is inserting a default of zero from the application, which is outside of the...

not sure about the trigger being what you want to do or not...

it should be an instead of trigger and not a FOR/AFTER trigger, i think

a float cannot have an...

jpomfret7 (2/13/2013)

---

Good Morning all,

I'm looking for a tool that would allow me to group objects together and assign permissions based on those groups. Such as Joe gets rights to all...