Viewing 15 posts - 586 through 600 (of 1,079 total)
vinodh247 (1/6/2011)
I have not copied these q's from any site, these are the questions i was asked in the interview. I'm a newbie to this site and this is my...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
January 6, 2011 at 2:11 am
Hardy21 (1/6/2011)
If we can setup PULL subscription at Enterprise level & pull the data from Express edition, is it possible?
Microsoft SQL Server 2008 Express (SQL Server Express) can serve as...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
January 6, 2011 at 2:06 am
I understand..the only other way I can think of is Policy Management (SQL 2008 up).
Haven't tried anything like this yet...
Trigger on create?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
January 6, 2011 at 2:01 am
Schedule a job to send mail to you with the following tsql...it will return with the names of databases created in the last day....
select name from sys.databases
where create_date > (getdate()...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
January 6, 2011 at 1:42 am
To add to what Adiga said, you can always make a normal backup, restore it as a different name, detach from SQL, and do as you please with the mdf...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
January 6, 2011 at 1:23 am
Let's rather start by you presenting us with the answers you gave, and we'll work from there?
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
January 5, 2011 at 11:56 pm
No you cant use Express as Distributor.
http://msdn.microsoft.com/en-us/library/ms165686.aspx
Replication Considerations (SQL Server Express)
SQL Server 2008 R2
Other Versions
* SQL Server "Denali"
* SQL Server 2008
...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
January 5, 2011 at 11:50 pm
In my age group, it's really the only way to keep in touch with people.
Nobody picks up the phone and call anymore, so FB is a good alternative.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
January 5, 2011 at 11:04 pm
In the job itself, add the 1st step as a 2nd step, and configure the first step's failure action to go to the next step, instead of reporting failure.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
January 5, 2011 at 10:59 pm
rmazambara (1/4/2011)
I would like to set up an audit for my sql server environment. I would like to audit changes that would have been done straight on database tables;...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
January 4, 2011 at 11:49 pm
declare @username nvarchar(35)
set @username = (select suser_name())
select loginname, (Case sysadmin when 1 then 'Yes' else 'No' end) as Sysadmin
from syslogins where loginname = @username
Passwords for NT linked accounts are...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
January 4, 2011 at 10:42 pm
exec sp_helplogins
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
January 3, 2011 at 2:03 am
In SSMS, right click the database you want to modify.
Select properties.
Select "Files" from the list on the left.
All files that belong to the database will be displayed (your database file,...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
December 30, 2010 at 3:59 am
You can set the maximum size for each file in your filegroup.
The filegroup size is the total of all the files sizes that belong to the group.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
December 30, 2010 at 1:01 am
I use getdate() purely as a habit.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
December 30, 2010 at 12:57 am
Viewing 15 posts - 586 through 600 (of 1,079 total)