Viewing 15 posts - 16 through 30 (of 42 total)
aarunkumarreddy (6/6/2011)
can you please send me some simple stored procedure for table alertsthankyou advance..
What kind of Alert,can you give us more specification?
June 6, 2011 at 10:26 pm
My Default fill factor is 0,
i am sorry that output from 32 bit sql server running on Window server 2008 32 bit edition in VMware.
June 6, 2011 at 5:42 am
I think you have run that test on 32 bit system.i am working on 64 bit.
I am getting same result you get on 32 bit system.i am able to insert...
June 6, 2011 at 5:25 am
I have attached output of
Exec sp_spaceused'ntinyint'
DBCC IND ('SANDBOX','ntinyint',-1)
in excel file.
June 6, 2011 at 5:00 am
yes,that is true ,Page header size is 96 byte.when i insert 51 Row ,47 rows goes in first Data page and then Sql server insert remaining 4 row in second...
June 6, 2011 at 4:41 am
Run following code it will execute successfully
declare @baslik nvarchar(max)=null
SET @baslik='Izmir''in en güzel yerleri'
Select @baslik
while when you run following code you will get error
declare @baslik nvarchar(max)=null
SET @baslik='Izmir'in en güzel yerleri'
Select @baslik
June 5, 2011 at 6:57 am
Yes,Cause ' character is used to start and end String.
when you want to insert that value in sql sever,you must provide 'Izmir''in en güzel yerleri' to sql server.
instead of 'Izmir'in...
June 5, 2011 at 6:51 am
sa.ordekci (6/5/2011)
this works ok. problem is that ' character. i use fckeditor. If i use this dinamic insert query ' character gives error. how can i solve this problem?
I...
June 5, 2011 at 6:34 am
here you goes.
SELECT COUNT(HardDisk) ,
HardDisk
FROM product
GROUP BY HardDisk
HAVING COUNT(HardDisk) >= 2
May 31, 2011 at 1:02 am
SKYBVI (5/30/2011)
Microsoft dynamics Great Plains
SQL server 2005
Acronis true image server and
symantec endpoint protection
Yes, im connected to right server for...
May 31, 2011 at 12:06 am
SKYBVI (5/30/2011)
RESTORE DATABASE RTW
FROM DISK = '\\servername\SQLBACKUP\RTW\RTW_backup_201105292015.bak'
WITH MOVE 'GPSRTWDat.mdf' TO 'E:\MSSQL\Data\RTW.mdf',
MOVE 'GPSRTWLog.ldf' TO 'E:\MSSQL\Data\RTW.ldf',
STATS=5
It does 30% and then throws this ERROR:--
30 percent processed.
Msg 3203,...
May 30, 2011 at 11:58 pm
GBeezy (5/30/2011)
SELECT *
FROM tablename
WHERE AccountID = '000001'
This returns a blank value as that AccountID does not exist in the table. But, instead of returning nothing, I need it...
May 30, 2011 at 11:52 pm
dastagiri16 (5/30/2011)
could you plz clarify
1.Main difference between transaction log and backup the tale log backup.
2.I take backupe tail log backup my database is in restore mode how can i...
May 30, 2011 at 10:46 pm
talismc (5/29/2011)
GilaMonster (5/29/2011)
Table definition (the create table statement) and the insert statement please
Here, I wrote a statement to create a new table to see if it would work but I...
May 30, 2011 at 12:57 am
Digs (5/28/2011)
What steps should I restore a .bak file with REPLACE selected.
you can following TSql Command to Restore Database with TSql Command.
USE master
RESTORE DATABASE Sandbox--YourDatabaseName
FROM DISK='D:\SQL SERVER\Lab\Backup\Backup_20110529_0903_Full.bak'--your backupFile Path.
WITH REPLACE
May 28, 2011 at 9:49 pm
Viewing 15 posts - 16 through 30 (of 42 total)