Viewing 15 posts - 5,416 through 5,430 (of 7,505 total)
And this guy is connecting using windows authentication ?
Or is he using SQL authentication ?
Which db groups is this user member off ?
(ddl_admin, ...)
If this user gets auth via a...
December 13, 2007 at 8:01 am
If they connect with the same credentials using OSQL and SSMS, it should work in the same way.
What's the default schema for the user ?
SQLCMD has more features than OSQL,...
December 13, 2007 at 5:08 am
I've tried and succeeded to "step into" the proc directly from a started VS2005 (without an open project) using the serverbrowser.
I haven't got a clue what's going wrong in your...
December 13, 2007 at 4:40 am
- maybe you may also want to migrate the most critical objects to a new filegroup, so they will not be influenced that much at shrink time.
- shrinking is done...
December 10, 2007 at 6:17 am
the "database project" icon is not in the same group as the Integration server or report server icon (Business Intelligence Projects), but you can find it in the "visual basic"...
December 10, 2007 at 5:01 am
Switch your SSMS settings to SQLCMD and you'll get a whole bunch of new statements available.
SSMS Query pane
tabl Query --- choose SQLCMD mode
:connect yyyyy
is the statement you're looking...
December 10, 2007 at 3:43 am
- did you check the replace statement ?
- maybe a function replacing them would serve you better (in stead of having to code it every single time over and again)
...
December 10, 2007 at 3:34 am
Welcome 😉
Indeed when googling the web many solutions go about clr-debugging.
For debugging an tsql-sproc with VS2005 (bi devstudio2005) ..
Don't use the CLR way !
Just:
- create a new db project
then
-...
December 10, 2007 at 3:26 am
- I'm told Xcopy should go faster than copy
- also first delete your old backup at the destination and copy the file afterward.
- There are solutions the can compress your...
December 6, 2007 at 3:00 am
there is off course the free SQL Server Migration Assistant for Access (SSMA Access)
http://www.microsoft.com/sql/solutions/migration/access/default.mspx
December 2, 2007 at 1:17 pm
you could use the sp_msforeachdb (undocumented !! :ermm: )
Check SSC for some examples ....
http://www.sqlservercentral.com/Forums/Topic307978-146-1.aspx#bm309930
December 1, 2007 at 9:19 am
- IMO referencing tables should reside on the same database for consistency and/or unit of recovery.
If you did split for performance reasons(split files), check out using filegroups....
December 1, 2007 at 9:14 am
more on SPN-info
make sure you can see the server registered with the actualy used portnumber ! (be carefull with dynamic ports !)
November 30, 2007 at 12:27 pm
We try to avoid these huge errorlog files by cycling them at least every week.
On our new servers the default is to cycle on a daily basis and keeping...
November 30, 2007 at 3:56 am
Viewing 15 posts - 5,416 through 5,430 (of 7,505 total)