Viewing 15 posts - 7,141 through 7,155 (of 13,469 total)
by design, SQL will use all the memory you care to feed it; so as time goes on, it might keep execution plans longer, since it has the memory to...
July 18, 2011 at 1:49 pm
server names with hyphens can be a problem.
do you get results with this command?
EXECUTE sp_tables_ex 'cyn-sqr'
--or
EXECUTE sp_tables_ex [cyn-sqr]
July 18, 2011 at 1:42 pm
what specific error do you get?
are you trying to connect via a trusted connection, or with a SQL username and password?
the more details you give, the more we can help!
July 18, 2011 at 1:35 pm
that's what i thought too, homebrew; i could see that if you didn't apply the DST patch in 2007 on your Windows operating System, where they moved the default DST...
July 18, 2011 at 12:41 pm
I'm downloading it now, but it's going to be an issue just like you see in a zip file, where you can save the absolutepaths or not as part of...
July 18, 2011 at 10:18 am
duplicate post.
no need to cross post to multiple forums it fractures the answers you get and makes posters duplicate others work.
the "Recent Posts" link shows us everything.
continue the thread here:
http://www.sqlservercentral.com/Forums/Topic1143507-1526-1.aspx
July 18, 2011 at 10:16 am
duplicate post.
no need to cross post to multiple forums it fractures the answers you get and makes posters duplicate others work.
the "Recent Posts" link shows us everything.
continue the thread here:
http://www.sqlservercentral.com/Forums/Topic1143507-1526-1.aspx
July 18, 2011 at 10:16 am
what's confusing you is there's no such thing as a global variable table. i know it seems a little intuitive that if two # signs make it global , it...
July 18, 2011 at 8:47 am
relaying is prohibited.
in order to avoid spam, a mail server, by default, will not deliver to an email address outside it's own domain unless
1. the sending IP address...
July 18, 2011 at 8:00 am
the servername for the mailserver is typically mail.mycompanyname.com, but can be something different.
you can go to http://www.mxtoolbox.com to input the real domain name and find the real mail server...
July 18, 2011 at 6:52 am
I believe connecting via the DAC(
dedicated Admin Connection ) automatically decrypts encrypted procs triggers and functions to allow diagnosis of problems.
July 18, 2011 at 6:03 am
that's easy...they are ALL server versions.
if it is installed as a service, it is the server version. always, no exceptions.
the client tools don't show up as a service
If you go...
July 18, 2011 at 5:57 am
well, whether you use a datatable like that on the fly, or a strongly typed dataset, the constraints should be the same, creating a duplicate structure of what exists in...
July 15, 2011 at 9:44 am
it's not an all-in-the-db or all-in-the-application kind of thing.
it's a mixture of both doing their parts to make sure the data is good.
generally you make sure your data has constraints...
July 15, 2011 at 9:22 am
great read, thanks for bring that to our attention!
July 15, 2011 at 8:38 am
Viewing 15 posts - 7,141 through 7,155 (of 13,469 total)