Viewing 15 posts - 6,301 through 6,315 (of 7,501 total)
I have altered the IPAll port, and even enabled the instance's own ipaddress with another port, but connecting using the latter ipaddress/port did not work !
Connecting using the ipaddress/"IPAll-port" worked...
April 20, 2006 at 7:32 am
altering the IPAll port, will have only that port active for connections when working with fixed ports.
(just done a quick test)
April 20, 2006 at 5:51 am
you databasesize has been shrunk.
it will try to shrink to it's original size, unless specified other size.
there is a procedure (which may need to be executed a number of times)...
April 20, 2006 at 5:42 am
I cannot see your screenshot, but here's how it works with an active/active cluster (x64).
I just testted it today. ![]()
SQL server configuration manager \...
April 20, 2006 at 4:00 am
this might occur when your database has autoshrink enabled.
If this is a production db, disable autoshrink, unless you like to have no control regarding when the shrink will occur !
alter...
April 20, 2006 at 3:26 am
Now this is a good parallel projection ![]()
As is the final solution ... bringing in another person can help you fix your problem in...
April 19, 2006 at 3:24 am
Wich permission set did you use when creating the assembly for SQLServer ?
CREATE ASSEMBLY xxxx from 'c:\xxxx.dll' WITH PERMISSION_SET = SAFE | EXTERNAL_ACCESS | UNSAFE
I guess for your...
April 14, 2006 at 6:55 am
I've set the SQLBrowser service account to "LocalService" but that did not to the trick.
After changing it to "Local System" SSAS was accessable, but the Server-browser (SSMS) did not show...
April 7, 2006 at 1:06 am
I didn't know the function, but sp_help fn_dblog gave some info.
use
your_db
go
declare
@StartLSN nvarchar(50)
April 7, 2006 at 12:41 am
now that's where the cautions come in ...
12 triggers on one object, may be a bit _to_ many ![]()
Maybe there is a way to...
April 7, 2006 at 12:25 am
declare @sql as varchar(5000)
set @sql = 'RESTORE FILELISTONLY FROM disk=''U:\MSSQL\backup\masterfull.bak'''
create table #tmpFilelist ( LogicalName nvarchar(128)
, PhysicalName nvarchar(260)
, [Type] char(1)
, FileGroupName nvarchar(128)
, [Size] numeric(20)
, [MaxSize] numeric(20)
 
April 3, 2006 at 1:03 am
First question that has to be asked : Does this all have to be in the same transaction-scope ? (on-line/realtime). Keep in mind, if the trigger fails, your sql-transaction also...
March 29, 2006 at 1:35 pm
Consider it as an extention to "Identity" ![]()
from books online (BOL)
If an application must generate an identifier column that is unique across the entire...
March 22, 2006 at 5:56 am
also keep in mind when defining your parameters, the better you allign with your sproc-parameter-datatype or column-datatype, the better your commandobject will be served.
Tell the system what you know !
you...
March 22, 2006 at 2:35 am
- Can you try to execute the queries without the TOP-keyword (and order by) in the views ?
- Like you can see, maybe you would be better off by altering...
March 21, 2006 at 2:42 am
Viewing 15 posts - 6,301 through 6,315 (of 7,501 total)